JDBC连接MySQL数据库

来源：互联网发布：mac os 10.11 cdr迅雷编辑：程序博客网时间：2024/06/07 18:46

JDBCSessionFectory.java

装载驱动
建立connection
创建statement
执行SQL语句
关闭资源

import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;public class JDBCSessionFactory {    private static final String DRIVERNAME = "com.mysql.jdbc.Driver";    //建立数据库连接，cms为数据库名，指定用户名和密码    private static final String URL =     "jdbc:mysql://localhost:3306/cms?useUnicode=true&characterEncoding=UTF-8";    private static final String USERNAME = "root";    private static final String PASSWORD = "admin";    private static Connection conn = null;    static{        try {            Class.forName(DRIVERNAME);        } catch (ClassNotFoundException e) {            e.printStackTrace();        }    }    public static Connection getConnection(){        try {            Connection conn = DriverManager.getConnection(URL,USERNAME,PASSWORD);            System.out.println("Success loading Mysql Driver!");            return conn;        } catch (SQLException e) {            System.out.print("Error loading Mysql Driver!");            e.printStackTrace();        }        return null;    }    public static void close(ResultSet rs,PreparedStatement ps,Connection conn){        try {            if(rs!=null){                rs.close();            }            if(ps!=null){                ps.close();            }            if(conn!=null){                conn.close();            }        } catch (SQLException e) {            e.printStackTrace();        }    }    public static void close(PreparedStatement ps,Connection conn){        try {            if(ps!=null){                ps.close();            }            if(conn!=null){                conn.close();            }        } catch (SQLException e) {            e.printStackTrace();        }    }    public static void close(Connection conn){        try {            if(conn!=null){                conn.close();            }        } catch (SQLException e) {            e.printStackTrace();        }    }}

阅读全文

0 0