dbmanager.java

jsp制作的一个信息管理系统源码,完整实用版

package common;

import java.sql.*;

/**
 * Title:DBManager
 * Description:锟斤拷菘锟斤拷锟斤拷撞锟斤拷锟斤拷
 * Copyright: Copyright (c) 2002
 * Company:
 * @author pwbell
 * @version 1.0
 */
 
public class DBManager {

	private String			myDriver  = null;
	private String			myConnStr = null;
	private Connection	        myConn 	  = null;
	private Statement		myStmt 	  = null;
	private ResultSet		myResults = null;

	/**
	 *锟借定锟斤拷锟斤拷锟絣锟斤拷锟街凤拷
	 *锟斤拷锟斤拷锟斤拷
	 */
	public DBManager() {
		
		/*
		DBConfig myConfig  = new DBConfig();
		
		myConfig.openConfig("config.ini");
		
		myDriver  = myConfig.getDriver();
		myConnStr = myConfig.getConnectString() 
					+ ";user=" + myConfig.getUser() 
					+ ";password=" + myConfig.getPassword();		
		*/
		myDriver  = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
		myConnStr = "jdbc:microsoft:sqlserver://localhost:1433;"
								+ "DatabaseName=RCData;User=aaa;Password=aaa";
		
		try {
			//System.out.println(myDriver);
			Class.forName(myDriver);
			System.out.println("锟斤拷锟斤拷锟斤拷爻晒锟斤拷锟