java怎么与mysql相连呢? 我找了好多但是都不行!那位高手帮帮忙!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 下载一个mysql-connector-java-5.1.13 jar包,然后其余的就是正常的数据库连接了 mysql-connector-java5.1.18mysql-connector-java5.1.6都不行!!我的QQ 837064956 public class JDBConnection { private final static String url = "jdbc:mysql://localhost:3306/student?user=root&password=123456&useUnicode=true&characterEncoding=gb2312"; private final static String dbDriver = "com.mysql.jdbc.Driver"; private Connection con = null; // 通过构造方法加载数据库驱动 static { try { Class.forName(dbDriver).newInstance(); } catch (Exception ex) { System.out.println("数据库加载失败"); } } // 创建数据库连接 public boolean creatConnection() { try { con = DriverManager.getConnection(url); con.setAutoCommit(true); } catch (SQLException e) { System.out.println(e.getMessage()); System.out.println("creatConnectionError!"); } return true; } // 对数据库的增加、修改和删除的操作 public boolean executeUpdate(String sql) { if (con == null) { creatConnection(); } try { Statement stmt = con.createStatement(); int iCount = stmt.executeUpdate(sql); System.out.println("操作成功,所影响的记录数为" + String.valueOf(iCount)); return true; } catch (SQLException e) { System.out.println(e.getMessage()); return false; } } // 对数据库的查询操作 public ResultSet executeQuery(String sql) { ResultSet rs; try { if (con == null) { creatConnection(); } Statement stmt = con.createStatement(); try { rs = stmt.executeQuery(sql); } catch (SQLException e) { System.out.println(e.getMessage()); return null; } } catch (SQLException e) { System.out.println(e.getMessage()); System.out.println("executeQueryError!"); return null; } return rs; }} 引入jar 再加上代码就ok了 给你一段连接ORACLE的代码,原理一样的import java.sql.*;public class ConnOracle{ public static void main(String[] args) { try{ Connection conn=null; Class.forName("oracle.jdbc.driver.OracleDriver"); conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:SCHOOL", "scott", "scott"); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery("select ename,job,mgr,hiredate,sal from emp"); // System.out.println("good"); while(rs.next()) { System.out.println(rs.getString(1)+" "); System.out.println(rs.getString(2)); System.out.println(rs.getString(3)); System.out.println(rs.getDate(4)); System.out.println(rs.getDouble(5)); System.out.println("-----------------------------"); } }catch(Exception e){ e.printStackTrace(); } }} 关于main方法内调用dll的问题 tomcat下能否部署两个相同的SSH应用 多表查询 Struts1 中,如何将数据提交到Form 中的 Set集合里? struts2表单输入验证 做了一个简单的SSH应用,但启动tomcat时总抛NoClassDefFoundError异常。 osworkflow-2.8.0的例子跑不通 如何在客户程序中(如javaBean或jsp)访问EJB返回的结果集数据 bmp中的ejbStore问题 jdialog的问题 求助!!jboss7.0.2配置mysql数据源错误 求解决
mysql-connector-java5.1.6
都不行!!我的QQ 837064956
public class JDBConnection {
private final static String url = "jdbc:mysql://localhost:3306/student?user=root&password=123456&useUnicode=true&characterEncoding=gb2312";
private final static String dbDriver = "com.mysql.jdbc.Driver";
private Connection con = null;
// 通过构造方法加载数据库驱动
static {
try {
Class.forName(dbDriver).newInstance();
} catch (Exception ex) {
System.out.println("数据库加载失败");
}
} // 创建数据库连接
public boolean creatConnection() {
try {
con = DriverManager.getConnection(url);
con.setAutoCommit(true); } catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("creatConnectionError!");
}
return true;
} // 对数据库的增加、修改和删除的操作
public boolean executeUpdate(String sql) {
if (con == null) {
creatConnection();
}
try {
Statement stmt = con.createStatement();
int iCount = stmt.executeUpdate(sql);
System.out.println("操作成功,所影响的记录数为" + String.valueOf(iCount));
return true;
} catch (SQLException e) {
System.out.println(e.getMessage());
return false;
}
} // 对数据库的查询操作
public ResultSet executeQuery(String sql) {
ResultSet rs;
try {
if (con == null) {
creatConnection();
}
Statement stmt = con.createStatement();
try {
rs = stmt.executeQuery(sql);
} catch (SQLException e) {
System.out.println(e.getMessage());
return null;
}
} catch (SQLException e) {
System.out.println(e.getMessage());
System.out.println("executeQueryError!");
return null;
}
return rs;
}}
import java.sql.*;
public class ConnOracle{
public static void main(String[] args) {
try{
Connection conn=null;
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:SCHOOL", "scott", "scott");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select ename,job,mgr,hiredate,sal from emp");
// System.out.println("good");
while(rs.next())
{
System.out.println(rs.getString(1)+" ");
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
System.out.println(rs.getDate(4));
System.out.println(rs.getDouble(5));
System.out.println("-----------------------------");
}
}catch(Exception e){
e.printStackTrace();
}
}}