jsp图书管理系统.zip

import java.sql.DriverManager; import java.sql.SQLException; import com.sun.corba.se.pept.transport.Connection; public class DBHelper{ private static final String driver = "com.mysql.jdbc.Driver"; //数据库驱动 //连接数据库的URL地址 private static final String url = "jdbc:mysql://localhost:3306/Library?useUnicode=true & characterEncoding=UTF-8"; private static final String username = "root";//数据库的用户名 private static final String password = "199702110"; // 数据库密码 private static Connection conn=null;//（导入类java.sql下的） //静态代码块负责加载驱动 static{ try{ Class.forName(driver); } catch(Exception ex){ ex.printStackTrace(); } } //单例模式返回数据库连接对象 public static Connection getConnection() throws Exception{ if(conn==null){ conn = (Connection) DriverManager.getConnection(url,username,password); return conn; } return conn; } public static void main(String[] args) throws Exception{ try{ Connection conn = DBHelper.getConnection(); if(conn!=null){ System.out.println("连接成功"); }else{ } }catch(SQLException e){ System.out.println("链接数据库的过程中出现SQL异常");} } }