dbaccess.java

为解决项目研发过程中Bug管理混乱、不科学以及中小型企业Bug管理过程中出现考核标准错误、规章制度过严等问题

package core;

import java.sql.*;

public class DBAccess {

	private String driverName = 
		"com.microsoft.sqlserver.jdbc.SQLServerDriver";
	private String url = 
		"jdbc:sqlserver://localhost:8080;" +
		   "databaseName=BugMgr;user=sa;password=123";
	
	public Connection getConnection()
	{
		try
		{
			Class.forName(driverName);
			Connection conn = DriverManager.getConnection(url);
			return conn;
		}
		catch(ClassNotFoundException cnfe)
		{
			cnfe.printStackTrace();
            return null;
		}
		catch(Exception e)
		{
			e.printStackTrace();
			return null;
		}
	}
	
	public boolean userExists(String userName, String userPwd)
	{
		try
		{
			DBAccess dbcm = new DBAccess();
			Connection conn = dbcm.getConnection();
			Statement stmt = conn.createStatement();
			ResultSet rs = stmt.executeQuery("select * from Manager where mana_username=? and mana_password=?");
			
			String username;
			String password;
			while(rs.next())
			{
				username = rs.getString(1);
				password = rs.getString(2);
				System.out.print("名称: "+username);
				System.out.print("\tpassword: "+password);
				return true;
			}
			return false;
		}
		catch(Exception e)
		{
			return false;
		}
	}
}