该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
UserDAO 我是先写了一个接口
package com.cn.pioneer.servers;
public interface UserDAO {
// 登录方法
public User login(String username,String password);
}
以下是我的实现方法
package com.cn.pioneer.servers;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.http.impl.cookie.DateUtils;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class UserDAOImpl implements UserDAO {
private final String DRIVER = "com.mysql.jdbc.Driver";
/**
* 子类可以修改url、username以及pwd的值
*/
private String url ="jdbc:mysql://localhost:3306/musicdream";
private String username = "root";
private String password = "123456";
public User login (String account, String password) {
String querySql = " select id,username,password "+
" from usertable "+
" where username=? and password=? ";
Connection connection=null;
DBUtil util = new DBUtil();
Connection conn = util.openConnection();
try {
//装载数据库驱动
Class.forName(DRIVER);
//建立数据库连接
connection = DriverManager.getConnection(url,username,password);
PreparedStatement state = conn.prepareStatement(querySql);
state.setString(1, username);
state.setString(2, password);
ResultSet result = state.executeQuery();
if (result.next()) {
int id = result.getInt(1);
String name = result.getString(4);
User user = new User();
user.setId(id);
user.setName(username);
user.setPassword(password);
return user;
}
}catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
public void setUrl(String url) {
this.url = url;
}
public void setUsername(String username) {
this.username = username;
}
public void setPwd(String password) {
this.password = password;
}
};