db.java

JSP版的网上书店系统

package shop;

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

public class DB {
    String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=shop";
    String user="sa";
    String password="sa";
	Connection connect = null;
	ResultSet rs = null;
	public DB() {
		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 	//璁剧疆椹卞姩绋嬪簭绫诲瀷		
		}
		catch(java.lang.ClassNotFoundException e) {
			e.printStackTrace();
		}
	}

    public boolean chechUser(String name ,String psw) {
    	boolean result=false;
    	String strSql;
    	strSql="select * from member where username='"+name+"'and password='"+ psw +"'";
    	try {
			connect = DriverManager.getConnection(url,user,password);
			
			Statement stmt = connect.createStatement();
			rs=stmt.executeQuery(strSql);
			if(rs.next()){
				result=true;
				System.out.println("1鏁版嵁搴撳凡缁忚繛鎺ヤ笂锛亊锛亊");
			}
		} catch (SQLException e) {
			e.printStackTrace();
			System.out.println("1鐢ㄦ埛鍚嶆垨瀵嗙爜涓嶆