JDBC连接Informix数据库相关操作.docVIP

JDBC的任务： 同一个数据库建立连接； 向数据库发送SQL语句； 处理数据库返回的结果。 JDBC基本工作步骤： Import the necessary classes Load the JDBC driver Identify the database source Allocate a “Connection” object (create) Allocate a “Statement” object (create) Execute a query using the “Statement” object Retrieve data from the returned “ResultSet” object Close the “ResultSet” object Close the “Statement” object Close the “Connection” object 由于用远程访问，所以需要一个ifxjbdc.jar包，将包放到指定目录下，用MyEclipse编译，代码如下： import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.sql.Connection; public class InformixDriver { public static void main(String args[]) throws ClassNotFoundException, SQLException{ String sql = select * from pet; Class.forName(com.informix.jdbc.IfxDriver); Connection con = DriverManager.getConnection (jdbc:informix-sqli://192.168.100.125:6666/test:informixserver=online_web;user=test;password=test654123); Statement stmt = con.createStatement(); ResultSet rs = stmt.executeQuery(sql); while(rs.next()){ System.out.println(rs.getString(sex)); System.out.println(rs.getString(name)); } rs.close(); con.close(); } } 调试结果如下： Fluffy m Clasws m Fang f Bowser f Chirpy m Whistler 插入操作： import java.sql.DriverManager; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class Jdbc { public static void main(String args[]) throws ClassNotFoundException, SQLException{ String sql = select * from pet; Class.forName(com.informix.jdbc.IfxDriver); Connection con = DriverManager.getConnection(jdbc:informix-sqli://192.168.100.125:6666/test:informixserver=online_web;user=test;password=test654123); Statement stmt = con.createStatement(); String r1 = insert into pet values(+Lily,Lucy,dog,m); stmt.executeUpdate(r1); ResultSet rs = stmt.executeQuery(sql); while(rs.next()){ System.out.printf(%s ,rs.getString(name)); System.out.printf(%s ,rs.getString(owne