JAVA类连接JDBC mysql

来源：互联网发布：android调用js方法编辑：程序博客网时间：2024/06/05 17:03

需要的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 exceptione.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}  return conn; }   public static void close(Connection conn) { if (conn!=null) { try {conn.close();} catch (SQLException e) {// TODO: handle exceptione.printStackTrace();} }  }  public static void close(PreparedStatement pstmt) { if(pstmt!=null) { try {pstmt.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} } }  public static void close(ResultSet rs) { if(rs!=null) {try {rs.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();} } } public static void main (String args[]) { getConnection(); } }

类直接ctrl+v就可以用

阅读全文

0 0