dbconnector.java

功能简单的网上电子书店 javabean

package database;
import java.sql.*;

public class DBconnector
{
	private static String db_username="mm";
	private static String db_password="123";
	private static String db_url="jdbc:sqlserver://127.0.0.1:1433;databaseName=bookstore";
	private static String db_driver="com.microsoft.sqlserver.jdbc.SQLServerDriver";
	//private static Connection con;
	private static Connection getConnection() 
	{
		Connection con = null;
		try
		{
			Class.forName(db_driver);
			con = DriverManager.getConnection(db_url, db_username,db_password);
		} 
		 catch (Exception ex) 
		{
			System.err.println("Message:  " + ex.getMessage());
		}
		return con;
	}
	private boolean checkAll(String u_name,String u_password)
	{
		//Connection con = getConnection();
		String query = "SELECT * FROM users " + "where UserName = '"
				+ u_name + "' and UserPassword = '" + u_password + "'";
		boolean res=false;
		try {
			Connection con = getConnection();
			Statement stmt = con.createStatement();
			stmt.execute("USE Bookstore;");
			ResultSet result = stmt.executeQuery(query);
			res = result.next();
			stmt.close();
			con.close();
		} catch (Exception se) {
			System.err.println("SQLException from Customer Information Checking: "
							+ se.getMessage());
		}
		return res;
	}
}