dbdao.java

用JSP制作的一个简单的登录界面

package org.baobao.dao;
import java.sql.*;
public class dbDao
{
	private static final String USERNAME="sa";
	private static final String USERPWD	="baobao";
	private static final String CLASSNAME="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	private static final String URL ="jdbc:microsoft:sqlserver://127.0.0.1:1433;databasename=Test";
	private static Connection con = null;
	
	public static Connection getCon()
	{
		try
		{
			Class.forName(CLASSNAME);
			con = DriverManager.getConnection(URL,USERNAME,USERPWD);
			return con;
		}catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}
	
	public static void close()
	{
		try
		{
			if (con != null)
			{
				con.close();
			}
		}catch(Exception e)
		{
			e.printStackTrace();
		}
	}
}