dbconnectionmanager.java

这个是用jsp做的网上购书系统

package org.pan.util;

import java.sql.*;

/**
 * Title:       数据库连接管理器
 * Description:
 * Copyright:    Copyright (c) 2003
 * Company:      多智能网络有限公司
 * @author:		 siny pan
 * @version 1.0
 */

public class DBConnectionManager {
    private String driverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";  //"oracle.jdbc.driver.OracleDriver";
    private String url = "jdbc:microsoft:sqlserver://localhost:1433";  //"jdbc:oracle:thin:@127.0.0.1:1521:oracle";
    private String user = "bookshop";
    private String password = "bookshop";

    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{
		
			DBConnectionManager dcm = new DBConnectionManager();
			Connection	conn = dcm.getConnection();
		    Statement stmt=conn.createStatement();
		    ResultSet rs=stmt.executeQuery("select * from my_BookAdminuser");
		    
			
		//	stmt = conn.createStatement();

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