java 链接mysql工具包代码
时间：2021-07-01 10:21:17
帮助过：11人阅读
connutil;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Connutil {
public static Connection Getconn(){
Connection conn =
null;
try {
Class.forName("com.mysql.jdbc.Driver"
);
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/homework","root","root"
);
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void closeconn(Connection conn,PreparedStatement ps,Statement sta,ResultSet rs){
try {
if(conn !=
null)
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
if(ps !=
null)
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
if(sta !=
null)
sta.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
try {
if(rs !=
null)
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
java 链接mysql工具包代码
标签：red localhost auto trace resultset color java get import
