java jdbc连接的完整过程 jdbc怎么连接的 我老是连接不上,怎么导入jdbc包希望能从头教我 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 public class DBCon { private static Connection con=null; public static Connection getCon(){ if(con==null){ try { Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@10.78.124.175:1521:report","report","report"); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return con; } public static void main(String[] args) { System.out.println(DBCon.getCon()); }} 你使用的是什么数据库,你只需要到这个数据jar到你的项目中就可以实现连接了,比如你使用oracle数据库,你就需要导入oracle的jar包。 在项目里建一个文件夹,把你要用的数据库驱动jar包放进去,在生成一下就可以了,至于代码,可以参考一楼的,希望能对你有用! package com.pyh.demo1;import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class ConnectionUtil { /** * 连接mysql数据库 * private String driver = "org.gjt.mm.mysql.Driver"; * private String url = "jdbc:mysql://127.0.0.1:3306/test"; * private String user = "root"; * private String pass = "admin"; */ //连接oracle数据库 private String driver = "oracle.jdbc.driver.OracleDriver" ; private String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl" ; private String user = "pyh" ; private String pass = "pyh300" ; private Connection conn; public ConnectionUtil() { try { Class.forName(driver); conn = DriverManager.getConnection(url, user, pass); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } } public Connection getConnection() { return conn; } public void close() { if (conn != null) { try { conn.close(); } catch (SQLException e) { e.printStackTrace(); } } } public static void main(String[] args) { System.out.println(new ConnectionUtil().getConnection()); }} struts2.2.1问题 浏览器打印问题 struts tab页面跳转问题 jsp dbcp优化提问,在线等。 easyui datebox 如何验证,就是有没有isValid方法。。急急急!!! 初级问题:Tomcat5.5运行jsp出错 <%%>里变量问题 急用。 求教 session怎么样才能赋值给变量! 求助:Mysql数据库连接异常 网页显示Access denied for user 'root'@'localhost' 这个位置为什么会报错的呢?小问题,我是小鸟,请老鸟帮我看看
public class DBCon {
private static Connection con=null;
public static Connection getCon(){
if(con==null){
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@10.78.124.175:1521:report","report","report");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
return con;
}
public static void main(String[] args) {
System.out.println(DBCon.getCon());
}}
package com.pyh.demo1;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;public class ConnectionUtil { /**
* 连接mysql数据库
* private String driver = "org.gjt.mm.mysql.Driver";
* private String url = "jdbc:mysql://127.0.0.1:3306/test";
* private String user = "root";
* private String pass = "admin";
*/
//连接oracle数据库
private String driver = "oracle.jdbc.driver.OracleDriver" ;
private String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl" ;
private String user = "pyh" ;
private String pass = "pyh300" ;
private Connection conn; public ConnectionUtil() {
try {
Class.forName(driver);
conn = DriverManager.getConnection(url, user, pass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
} public Connection getConnection() {
return conn;
} public void close() {
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
} public static void main(String[] args) {
System.out.println(new ConnectionUtil().getConnection());
}
}