2020-03-17

求救，user返回值为空
package mybean;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class UserDAO {

public User login(String username,String password) {
	Connection conn=JDBC.getConnection();
	String sql="select * from tb_user where username='"+username+"'";
	System.out.println(sql);
	
	Statement stmt=null;
	ResultSet rs=null;
	User user=null;
	try {
		stmt=conn.createStatement();
		rs=stmt.executeQuery(sql);
		if(rs.next()) {
			if(password.equals(rs.getString("password"))) {
				user= new User();
				//user.setId(rs.getInt("id"));
				user.setUsername(rs.getString("username"));
			}
		}
	}catch(SQLException e) {
		e.printStackTrace();
	}
	return user;

}