dbconnection.java

jsp实现医院门诊系统

package com.hospital.util;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import com.hospital.util.DBConnection;

 /**
    该类主要用于数据库连接
 **/

public class DBConnection {
    
	//设置数据库连接驱动
    private String driverName = "org.gjt.mm.mysql.Driver"; 
    private String url = "jdbc:mysql://localhost:3306/hospital?useUnicode=true&characterEncoding=GBK";  
    private String user = "root";
    private String password = "123456";

    //设置驱动名称
    public void setDriverName(String newDriverName) {  
        driverName = newDriverName;                          
    }
    //取得驱动名称
    public String getDriverName() {
        return driverName;
    }
	//设置连接语句
    public void setUrl(String newUrl) {
        url = newUrl;
    }
    //取得连接语句
    public String getUrl() {
        return url;
    }
    //设置数据库连接用户名
    public void setUser(String newUser) {
        user = newUser;
    }
    //取得数据库连接用户名
    public String getUser() {
        return user;
    }
    //设置密码
    public void setPassword(String newPassword) {
        password = newPassword;
    }
    //取得密码
    public String getPassword() {
        return password;
    }
    //取得数据库的连接
    public Connection getConnection() {
        try {
            Class.forName(driverName);
            return DriverManager.getConnection(url, user, password);
        }
        catch (Exception e) {
            e.printStackTrace();
            return null;
        }
    }
    //测试数据库的连接
    public static void main(String[] args) {
       // DBConnectionManager DBConnectionManager1 = new DBConnectionManager();


		try{
		
			DBConnection dcm = new DBConnection();
			Connection	conn = dcm.getConnection();
		    Statement stmt=conn.createStatement();
		    ResultSet rs=stmt.executeQuery("select * from my_users");
		    
			
		//	stmt = conn.createStatement();

		    while(rs.next()){
				System.out.print("名称: "+rs.getString(2));
				System.out.print("\tpassword: "+rs.getString(5));
				System.out.println();
		    }
			//stmt.executeUpdate( "insert into my.txt values ('Ruby',27,'网络部')");		    
		}catch(Exception e){
		    e.printStackTrace();
		}
    }
}