userpwddao.java

利用SQLServer2000实现电话本功能

import java.sql.*;
public class userpwdDAO {
	public boolean checkUser(String username,String pwd) throws SQLException{
		Statement stmt=CreateConnection.conn.createStatement();
		ResultSet rs=stmt.executeQuery("select * from userpwd where username='"+username+"'and pwd='"+pwd+"'");
		boolean isFind=rs.next();
		stmt.close();
		return isFind;
	}
	
	public boolean checkUserName(String username) throws SQLException{
		Statement stmt=CreateConnection.conn.createStatement();
		ResultSet rs=stmt.executeQuery("select * from userpwd where username='"+username+"'");
		boolean isFind=rs.next();
		stmt.close();
		return isFind;
	}
	
	public boolean createUser(String username,String pwd) throws SQLException{
		Statement stmt=CreateConnection.conn.createStatement();
		int rs=stmt.executeUpdate("insert into userpwd values('"+username+"','"+pwd+"')");
		stmt.close();
		return rs>0;
	}
}