logindao.java

简单的SREVLET的实验项目 大家可以下载试用一下看看或许有什么帮助

package com.zg.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;



import com.sun.corba.se.spi.orbutil.fsm.Guard.Result;
import com.zg.bean.LoginBean;
import com.zg.util.DBConn;

public class LoginDAO {
    
	public static boolean addUser(LoginBean lbean ){
		boolean flag = false;
		
		Connection conn = DBConn.getConn();
		PreparedStatement pst = null;
	    List list = new ArrayList();
		
		String sql = "insert into login values(?,?)";

		try {
			pst = conn.prepareStatement(sql);
			
			pst.setString(1,lbean.getUsername());
			pst.setString(2,lbean.getPassword());
			
			int x = pst.executeUpdate();
			
			if(x>0){
				flag= true;
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		finally{
			
			try {
				pst.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		return flag;
	}
	public static LoginBean selectUser(LoginBean lbean){
		LoginBean lbean1 = new LoginBean();
		
		Connection conn = DBConn.getConn();
		PreparedStatement pst = null;
		ResultSet rs = null;
		
		String sql = "select * from login where username=? and password=?";
		
		try {
			pst= conn.prepareStatement(sql);
			
			pst.setString(1, lbean.getUsername());
			pst.setString(2,lbean.getPassword());
			
			rs = pst.executeQuery();
			
			while(rs.next()){
			  	
			  lbean1.setUserid(rs.getInt(1));	
			  lbean1.setUsername(rs.getString(2));
			  lbean1.setPassword(rs.getString(3));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	   finally{
			
			try {
				pst.close();
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		
		return lbean1;
	}
}