usersdb.java

用java做的网上商店系统！代码完整。希望为大家有所帮助！

package org.qhit.shop.db;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class UsersDB {
	//验证登陆的方法(返回该用户相关信息)
	public UsersBean isLogin(UsersBean ub){
		UsersBean u=null;
		Connection conn=null;
		PreparedStatement ps=null;
		ResultSet rs=null;		
		String sql="select id,uname,qx from users where uname=? and pass=?";
		try {
			//1.创建连接
			conn=DBConn.getConn();
			//2.创建指令集对象
			ps=conn.prepareStatement(sql);
			ps.setString(1, ub.getUname());
			ps.setString(2, ub.getPass());
			//3.执行SQL指令
			rs=ps.executeQuery();			
			if(rs.next()){
				u=new UsersBean();
				u.setId(rs.getInt(1));
				u.setUname(rs.getString(2));
				u.setQx(rs.getInt(3));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				if(rs!=null)rs.close();
				if(ps!=null)ps.close();
				DBConn.close(conn);
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return u;		
	}
}