JAVA类连接JDBC mysql

需要的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就可以用