informix.txt

jsp与数据库开发的全部代码

Class.forName("com.informix.jdbc.IfxDriver").newInstance();
//datebase为所要连接的数据库名
String url ="jdbc:informix-sqli://123.45.67.89:1533/datebase:INFORMIXSERVER=myserver;
//设置登录用户名
user=testuser;
//设置登录密码
password=testpassword";
//创建数据库连接
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, 
ResultSet.CONCUR_UPDATABLE);
//取出test表内的所有字段
String sql="select * from test";
//执行sql语句
ResultSet rs=stmt.executeQuery(sql);