usersdao.java

来自「对入学者很实用用JAVA的基本语言写的」· Java 代码 · 共 49 行

package com.TestB.dao;

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

import com.TestB.domain.Users;
import com.TestB.util.DbUtils;

public class UsersDAO {

	public Users login(String sname,String spass)
	{
		Connection conn = null;
        PreparedStatement state = null;
        ResultSet rs = null;

        Users user = new Users();
        try {
            conn = DbUtils.getConn();
            state = conn.prepareStatement("select * from useInfo where sname=? and spass=?");
            state.setString(1, sname);
            state.setString(2, spass);          
            rs = state.executeQuery();

            if (rs.next()) {
                
                user.setSid(rs.getInt("sid"));
                user.setSname(rs.getString("sname"));
                user.setSpass(rs.getString("spass"));
                user.setSage(rs.getInt("sage"));
                user.setSaddress(rs.getString("saddress"));
                return user;
            }
           
        
        } 
        catch(Exception e)
        {
         e.printStackTrace();	
        }finally {
            DbUtils.close(rs, state, conn);
        }
       return null;

	}
}