谁能给点提示? 我也知JDBC,但就不知具体过程! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 import java.sql.*Class.forName("com.informix.jdbc.IfxDriver").newInstance(); String url = "jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver;user=rdtest;password=test"; //testDB为你的数据库名 Connection conn= DriverManager.getConnection(url); Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); String sql="select * from test"; ResultSet rs=stmt.executeQuery(sql); while(rs.next()) {System.out.println("您的第一个字段内容为:"+rs.getString(1));System.out.println("您的第二个字段内容为:"+rs.getString(2));}System.out.print("数据库操作成功,恭喜你");rs.close(); stmt.close(); conn.close(); //操作ACCESS数据库Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:MyClass"); Statement stmt = con.createStatement(); ResultSet result = stmt.executeQuery("select * from Class"); while(result.next()){ String name = result.getString("Name"); Date Birthday= result.getDate("Birthday"); int phone = result.getInt("phone"); } con.close();}catch(Exception e){ System.out.println(e.toString());}//----------- JDBC----------- try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:MyClass"); Statement stmt = con.createStatement(); ResultSet result = stmt.executeQuery("select * from Class"); while(result.next()){ String name = result.getString("Name"); Date Birthday= result.getDate("Birthday"); int phone = result.getInt("phone"); } con.close();}catch(Exception e){ System.out.println(e.toString());} java线程锁同步问题,刚接触线程锁,出错了,代码很少,请看 Vector线程安全,ArrayList线程不安全问题。 发布j2ee项目出现乱码,谁来解决一下? 树状的模式怎么搞 我的一个JSP系统在重装环境后无法显示,请高手帮忙 急急急,请高手帮忙,字符的问题 求助!!! 初学JAVA求教“引用”的含有 这个错误提示是怎么回事??? 请高手添加背景图片和音乐 thinking in java 的迷惑 如何引用.jar
String url =
"jdbc:informix-sqli://123.45.67.89:1533/testDB:INFORMIXSERVER=myserver;
user=rdtest;password=test";
//testDB为你的数据库名
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
System.out.println("您的第一个字段内容为:"+rs.getString(1));
System.out.println("您的第二个字段内容为:"+rs.getString(2));
}
System.out.print("数据库操作成功,恭喜你");
rs.close();
stmt.close();
conn.close();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:MyClass");
Statement stmt = con.createStatement();
ResultSet result = stmt.executeQuery("select * from Class"); while(result.next()){
String name = result.getString("Name");
Date Birthday= result.getDate("Birthday");
int phone = result.getInt("phone");
}
con.close();
}catch(Exception e){
System.out.println(e.toString());
}//----------- JDBC-----------
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:MyClass");
Statement stmt = con.createStatement();
ResultSet result = stmt.executeQuery("select * from Class"); while(result.next()){
String name = result.getString("Name");
Date Birthday= result.getDate("Birthday");
int phone = result.getInt("phone");
}
con.close();
}catch(Exception e){
System.out.println(e.toString());
}