java数据库编程!!! 我是一个java学习者新手,请大虾们给点学习建议,java数据库编程的学习资料,我有一份是英语的(OReilly - Database Porgramming With Jdbc And Java 2nd Edition.pdf)数据库编程文档,可以给我一份中文的吗?我找过好多地方都没有找到中文的,谢谢大虾帮忙!!!谢谢大虾指点一二!!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 给你集中连接数据库的代码:连接mysql 在lib下添加 mysql-connector-java-5.0.6-bin.jar package com.demo.xu; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DBUtil { private static Connection conn=null; private static final String DRIVER= "com.mysql.jdbc.Driver"; private static final String URL= "jdbc:mysql://localhost/test?user=root&password=111111"; static { try { Class.forName(DRIVER).newInstance(); } catch (Exception e) { e.printStackTrace(); } } public synchronized static Connection getConn()throws SQLException { return DriverManager.getConnection(URL); } public static void main(String[] args) throws SQLException { String sql="select *from users"; conn=DBUtil.getConn(); Statement sta=conn.createStatement(); ResultSet rs=sta.executeQuery(sql); while(rs.next()){ System.out.println(rs.getString(3)); } } } 连接sql2005 lib下导入sqljdbc.jar package com.demo.xu; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class SQLDB { private static Connection conn=null; private static final String DRIVER= "com.microsoft.sqlserver.jdbc.SQLServerDriver"; private static final String URL= "jdbc:sqlserver://localhost:1433;databaseName=test"; private static String ename="sa"; private static String pwd="xu123"; static { try { Class.forName(DRIVER).newInstance(); } catch (Exception e) { e.printStackTrace(); } } public static Connection getConn()throws SQLException{ return DriverManager.getConnection(URL,ename,pwd); } public static void main(String[] args) throws SQLException { conn=SQLDB.getConn(); System.out.println(conn.toString()); } } oralce10g连接 libclasses12.jar package com.demo.xu; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; public class oracleDB { private static Connection conn=null; private static final String DRIVER= "oracle.jdbc.driver.OracleDriver"; private static final String URL= "jdbc:oracle:thin:@localhost:1521:ORCL"; // ORCl:为oracle服务名称 private static String ename="system"; private static String pwd="system"; static { try { Class.forName(DRIVER).newInstance(); } catch (Exception e) { // TODO: handle exception } } public static Connection getConn()throws SQLException { return DriverManager.getConnection(URL,ename,pwd); } public static void main(String[] args) throws SQLException { conn=oracleDB.getConn(); System.out.println(conn.toString()); } } 哪位帮我看看这个页面到底哪里有问题,无法再浏览器显示,眼都瞪晕了 JSP请问这段代码错了吗 内存溢出 问什么这个方法没有执行??自己看不出来,请教高手?? jdbc访问oracle function的问题 请问在JSP中怎么开发日志程序 用Struts+Hibernate 这样子得不到值是什么原因? 求大神指教 Jbuilder编译错误,是什么错误,请大侠指点? 请教如何使一个弹出IE小窗口总在最前? 怪啊!... 怎么实现div背景透明 hibernate映射的问题
在lib下添加 mysql-connector-java-5.0.6-bin.jar
package com.demo.xu; import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement; public class DBUtil { private static Connection conn=null;
private static final String DRIVER=
"com.mysql.jdbc.Driver";
private static final String URL=
"jdbc:mysql://localhost/test?user=root&password=111111"; static {
try {
Class.forName(DRIVER).newInstance();
} catch (Exception e) {
e.printStackTrace();
}
} public synchronized static Connection getConn()throws SQLException {
return DriverManager.getConnection(URL);
} public static void main(String[] args) throws SQLException {
String sql="select *from users";
conn=DBUtil.getConn();
Statement sta=conn.createStatement();
ResultSet rs=sta.executeQuery(sql);
while(rs.next()){
System.out.println(rs.getString(3));
}
}
}
连接sql2005 lib下导入sqljdbc.jar
package com.demo.xu; import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException; public class SQLDB {
private static Connection conn=null;
private static final String DRIVER=
"com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String URL=
"jdbc:sqlserver://localhost:1433;databaseName=test";
private static String ename="sa";
private static String pwd="xu123"; static {
try {
Class.forName(DRIVER).newInstance();
} catch (Exception e) {
e.printStackTrace();
}
} public static Connection getConn()throws SQLException{
return DriverManager.getConnection(URL,ename,pwd);
}
public static void main(String[] args) throws SQLException {
conn=SQLDB.getConn();
System.out.println(conn.toString());
}
} oralce10g连接
libclasses12.jar package com.demo.xu; import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException; public class oracleDB {
private static Connection conn=null;
private static final String DRIVER=
"oracle.jdbc.driver.OracleDriver";
private static final String URL=
"jdbc:oracle:thin:@localhost:1521:ORCL";
// ORCl:为oracle服务名称
private static String ename="system";
private static String pwd="system"; static {
try {
Class.forName(DRIVER).newInstance();
} catch (Exception e) {
// TODO: handle exception
}
} public static Connection getConn()throws SQLException {
return DriverManager.getConnection(URL,ename,pwd); }
public static void main(String[] args) throws SQLException {
conn=oracleDB.getConn();
System.out.println(conn.toString());
}
}