condatabase.java

基于java/mysql的图书管理系统,主要使用的技术有java+jsp+tomcat+mysql+eclipse jdk版本1.6.0

package com.zyuntao.struts.database;

import java.sql.*;


/**
 * 此类用来实现数据库连接
 */
public class Condatabase {

	private String jdbcURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=zyt;user=sa;password=";


	public Condatabase()
			 {
	}

	public Condatabase(String driverClass, String jdbcURL)
	throws ClassNotFoundException {
		driverClass="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Class.forName(driverClass);
this.jdbcURL = jdbcURL;
}
	public void setDriver(String driverClass, String jdbcURL)
			throws ClassNotFoundException {
		driverClass="com.microsoft.jdbc.sqlserver.SQLServerDriver";
		Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		jdbcURL ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=zyt;user=sa;password=";
this.jdbcURL=jdbcURL;
	}

	public Connection getConnection() throws SQLException {

		Connection con = DriverManager.getConnection(jdbcURL);
		return con;
	}
}