需要的jar包mysql
mysql-connector-java-5.1.39-bin.jar
class类代码
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class DBConnection {
private static final String DBDRIVER="com.mysql.jdbc.Driver";//驱动
private static final String DBURL="jdbc:mysql://localhost:3306/test";//test为数据库名称
private static final String DBUSER="root";//数据库用户名
private static final String DBPASSWORD="";//数据库默认密码 默认为空
public static Connection getConnection()
{
Connection conn=null;
try {
Class.forName(DBDRIVER);
//获得链接对象
conn=DriverManager.getConnection(DBURL,DBUSER,DBPASSWORD);
if(conn!=null)
{
System.out.print("连接成功1");
}
} catch (ClassNotFoundException e) {
// TODO: handle exception
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void close(Connection conn)
{
if (conn!=null)
{
try {
conn.close();
} catch (SQLException e) {
// TODO: handle exception
e.printStackTrace();
}
}
}
public static void close(PreparedStatement pstmt)
{
if(pstmt!=null)
{
try {
pstmt.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void close(ResultSet rs)
{
if(rs!=null)
{
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void main (String args[])
{
getConnection();
}
}
类直接ctrl+v就可以用