userpeopled.java

实现在线的增删改查和一些基本的功能！这是一个简单的网页！

package 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 model.Userpeople;

import Util.DBHelper;

public class UserPeopleD {
	private PreparedStatement ps;
	private ResultSet rs;
	/***
	 * 得到数据库中所有的用户
	 * *****/
	public List getAllUser(){
		List list=new ArrayList();
		Connection conn=DBHelper.getCon();
		String sql="select*from Userpeople";
		try {
			ps=conn.prepareStatement(sql);
			rs=ps.executeQuery();
			while(rs.next()){
				Userpeople user=new Userpeople();
				user.setUserid(rs.getInt("userid"));
				user.setUsername(rs.getString("username"));
				user.setUserpassword(rs.getString("password"));
				user.setUsetype(rs.getInt("type"));
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		return list;
		
	}
	/******根据用户名和用户编号获取一个登陆用户*****/
	public Userpeople getUserByUsernamePassword(String Username,String Userpassword){
		Userpeople user=null;
		Connection conn=DBHelper.getCon();
		String sql="select * from Userpeople where Username=? and Userpassword=?";
		try {
			ps=conn.prepareStatement(sql);
			ps.setString(1, Username);
			ps.setString(2, Userpassword);
			rs=ps.executeQuery();
			if(rs.next()){
				user=new Userpeople();
				
				user.setUserid(rs.getInt("Userid"));
				user.setUsername(rs.getString("Username"));
				user.setUserpassword(rs.getString("Userpassword"));
				//user.setUsetype(rs.getInt("usetype"));
			}
			
		} catch (SQLException e) {

          
			e.printStackTrace();
		}
		return user;
		
	}
	
	public static void main(String[] args) {
		UserPeopleD dao = new UserPeopleD();
		
		if(dao.getUserByUsernamePassword("sa", "sa") != null){
			System.out.println("ok");
		} else {
			System.out.println("error");
		}
	}
	/*******/

	
	
	
}