daouserinfo.java

java语言中servlet的用法实例

package blogServlet;

public class DaoUserInfo {
//	private java.sql.Connection conn;
	private static SqlConnection sqlCon = new SqlConnection();
	
	public static boolean userLoginConfirm(String name,String  pwd){
		System.out.println("Enter userLoginConfirm of DaoUserInfo");
		String sql = "select * from userinfo where name like '"+name+"' and pwd like '"+pwd+"';";
		try{
		java.sql.Connection conn = sqlCon.getConn();
		java.sql.Statement stmt = conn.createStatement();
		java.sql.ResultSet rs = stmt.executeQuery(sql);
		if(rs.next()){
			return true;
		}
		}catch(Exception ex){
			ex.printStackTrace();
		}
		return false;
	}
	
	public static boolean setUserInfo(String name,String pwd){
		System.out.println("Enter setUserInfo of DaoUserInfo");
		String sql = "insert into userinfo(name,pwd) values('"+name+"','"+pwd+"');";
		try{
			java.sql.Connection conn = sqlCon.getConn();
			java.sql.Statement stmt = conn.createStatement();
			int i = stmt.executeUpdate(sql);
			if(1==i){
				return true;
			}
		}catch(Exception ex){
			ex.printStackTrace();
		}
		return false;
	}
}