在这里插入代码片
package util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class jdbcutil {
public static Connection getCon() throws Exception {
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/library" // library是数据库的名字
+ "?useUnicode=true&characterEncoding=UTF-8";
Connection con = DriverManager.getConnection(url,"root","root");// 第一个root是账号,第二个root是密码
return con;
}
public static void close(ResultSet rs, Statement stmt,Connection con ) throws Exception{
rs.close();
stmt.close();
con.close();
}
}
mysql-connector-java-5.1.21.jar 需要导入这个包右键 build path