usersdao.java

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

package com.TestA.dao;

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


import com.TestA.domain.Users;
import com.TestA.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.setSaddress(rs.getString("saddress"));
                return user;
            }
        } 
        catch(Exception e)
        {
         e.printStackTrace();	
        }finally {
            DbUtils.close(rs, state, conn);
        }
       return null;

	}
	
	public void update(Integer sId,String saddress)
	{
	   Connection conn = null;
	   PreparedStatement state = null;
	   
	   try
	   {
		String sql = "update useInfo set saddress=? where sid=?";   
		conn = DbUtils.getConn();
		state = conn.prepareStatement(sql);
        state.setString(1, saddress);
        state.setInt(2, sId);
        state.executeUpdate();
	   }
	   catch (Exception e)
	   {
		 e.printStackTrace();  
	   }
	   finally
	   {
		 DbUtils.close(null, state, conn);  
	   }
		
	}
}