basedao.java

jsp对列车有查询功能jsp对列车有查询功能

package li.s2.dao;

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

public class BaseDAO {
	
	//驱动
	private final String DRIVER="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	//连接字符
	private final String URL="jdbc:microsoft:sqlserver://localhost:1433;databaseName=train";
	//用户名
	private final String USER="sa";
	//密码
	private final String PWD="sa";
	/**
	 * 获得数据库连接 
	 * @return Connection
	 * @throws ClassNotFoundException
	 * @throws SQLException
	 */
	public Connection getConn() throws ClassNotFoundException, SQLException{
		Connection con = null;
		Class.forName(DRIVER);
		con = DriverManager.getConnection(URL,USER,PWD);
		return con;
	}
	/**
	 * 关闭三大对象 
	 * @param rs
	 * @param st
	 * @param con
	 * @throws SQLException
	 */
	public void CloseAll(ResultSet rs ,Statement st,Connection con) throws SQLException{
		if(rs!=null)
			rs.close();
		if(st!=null)
			st.close();
		if(con!=null)
			con.close();
	}
	/**
	 * 连接测试方法
	 * @param args
	 */
	public static void main(String[] args) {
		BaseDAO baseDAO = new BaseDAO();
		Connection con = null;
		try {
			con = baseDAO.getConn();
			System.out.println("OK");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}finally{
			try {
				baseDAO.CloseAll(null, null, con);
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}