dbutil.java

jsp网页

package com.rfid.global;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DbUtil {
	private static String sDBDriver = "com.mysql.jdbc.Driver";
	private static String sConnStr = "jdbc:mysql://localhost:3306/rfid" ;
	private static String dbUser = "root";
	private static String dbPwd = "root";
   
	
	public static Connection getConnection(){
		Connection conn = null;
        try {
			Class.forName(sDBDriver).newInstance();
	        conn = DriverManager.getConnection(sConnStr,dbUser,dbPwd);
		} catch (InstantiationException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
        return conn;
	}
}