databaseconnection.java

本人做的个人留言本

package com.connection;

import java.sql.*;

public class DataBaseConnection {
	private String DBDRIVER = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
	private String DBURL = "jdbc:microsoft:sqlserver://localhost:1433;databaseName=webnote";
	private String DBUSER = "admin";
	private String DBPASSWORD = "123456";
	private Connection conn = null;

	public DataBaseConnection() {
		
			try {
				Class.forName(DBDRIVER);
				this.conn = DriverManager.getConnection(DBURL, DBUSER, DBPASSWORD);
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		
	}

	public Connection getConnection() {
		return this.conn;
	}

	public void close() {
		
			try {
				this.conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
	}
};