hibernate mysql驱动包

作者: 沙皮狗的忧伤丿
来源: 51数据库
2020-12-21

你的mysql的驱动包没有导入那把String drive="com.mysql.jdbc.driver"; 改成String drive="com.mysql.jdbc.Driver"; 在result=sm.executeQuery(str);后加上 while(result.next()) { System.out.println(result.getString("name")); System.out.println(result.getString("userid")); System.out.println(result.getString("password")); System.out.println(result.getString("email")); }

数据库文件存储在mysql安装目录下的data目录.

package org;
import java.sql.*;

public class dbconnection{

private string dbdriver = "org.gjt.mm.mysql.driver";
private string myurl = "jdbc:mysql://localhost:3306/mytest";
private string user = "root";
private string password = " http://lovebeyond19831993.blog.163.com";

connection conn = null;

dbconnection(){ //构造函数

  try{
    class.forname(dbdriver);
  }
  catch(exception e){ e.printstacktrace(); }

  try{
    conn = drivermanager.getconnection(myurl,user,password);
  }
  catch(sqlexception s){ s.printstacktrace(); }

}

public connection getconnection(){ //返回connectin类型

  return conn;
}

public void getclose(){ //关闭数据库连接

  try{
    this.conn.close();
  }
  catch(exception e){ e.printstacktrace(); }
}
}