我也知JDBC,但就不知具体过程!
解决方案 »
- Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
- 菜鸟问问
- java socket email 问题
- 很简单的数组输出的问题,有点不明白
- jdbc和php的速度问题?
- 用java如何实现对自己机子某些程序的打开/关闭、最大化/最小化、隐藏与显示等
- if ...else if...语句的问题
- 如何能将字符串中的所有数字都删除
- 用java做一个批量下载网页(象FlashGet那样)的工具需要哪些技术知识,有没有相关的sourcecode可参考?
- 关于LDAP
- 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());
}