创建一个web项目名为bbb
1 创建数据库连接
(1)创建一个包cn.edu.hpu.util
(2)写代码
package cn.edu.hpu.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DBOperate {
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection () {
Connection conn=null;
try {
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/sas", "root", "123456");
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
public static void close(Statement st,ResultSet rs,Connection conn) {
try {
if(st!=null) {
st.close();
}
if(rs!=null) {
rs.close();
}
if(conn!=null) {
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void close(PreparedStatement pst,Connection conn) {
try {
if(pst!=null) {
pst.close();
}
if(conn!=null) {
conn.close();
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
写一个使用者类
(1)创建包cn.edu.hpu.user
(2)写代码
package cn.edu.phu.user;
public class User {
private int id;
private String username;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}
创建管理接口和其实现类
(1)创建包cn.edu.hpu.manager
(2)写接口代码
package cn.edu.hpu.manager;
import cn.edu.phu.user.User;
public interface Manager {
public User CheckLogin(String username, String password);
public boolean RegestUser(User u);
}
实现接口的类
package cn.edu.hpu.manager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import cn.edu.hpu.util.DBOperate;
import cn.edu.phu.user.User;
public class ManagerImpl implements Manager {
public User CheckLogin(String username , String password) {
User u =new User();
String sql="select * from ta";
Connection conn=null;
Statement st=null;
ResultSet rs=null;
conn=(Connection) DBOperate.getConnection();
try {
//Statement createStatement()
//创建一个 Statement 对象来将 SQL 语句发送到数据库。
//编译
st=(Statement) conn.createStatement();
//从数据库里查的内容作为结果集
rs=(ResultSet) st.executeQuery(sql);
//遍历这个结果集
while (rs.next()) {
String name=rs.getString("username");
String psw=rs.getString("password");
if