请各位帮我分析下这段java代码，谢谢啊

显示全部楼层 · 2009-6-5 14:42:32

package edu.aic.stock.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import edu.aic.stock.sql.ConnectionFactory;
public class LoginDao {

private PreparedStatement prepareStatement;
private ResultSet resultSet;

public int login(String name,String pwd) throws Exception{
String sql = "select * from users where u_name = ?";
Connection conn = ConnectionFactory.getConnection();
prepareStatement = conn.prepareStatement(sql);
prepareStatement.setString(1, name);
resultSet = prepareStatement.executeQuery();
if(!resultSet.next()){
return 0;
}

String pwdDB = resultSet.getString("u_password");
if(pwdDB.equals(pwd)){
return 2;
}else{
return 1;
}
}

public static void main(String a[]){
LoginDao loginDao = new LoginDao();
try {
System.out.println(loginDao.login("1", "1"));
} catch (Exception e) {

}
}
}

千问 · 2009-6-5 14:42:32

public class LoginDao {声明处理链接sql 对象private PreparedStatement prepareStatement; 声明返回结果集对象 private ResultSet resultSet; //根据账户密码登陆 public int login(String name,String pwd) throws Exception{
// 数据库连接语句 String sql = "select * from users where u_name = ?";由ConnectionFactory 类工厂创建Connection数据库连接Co...

千问 · 2009-6-5 14:42:32

首先根据用户名来查询是否有这条数据有的话把密码取出来在和传递过来的密码进行比较登陆的例子...

千问 · 2009-6-5 14:42:32

判断用户名和密码是否正确，就是个简单的登陆验证...