首先创建一个web项目,然后配置tomcat服务器,配置完之后部署项目
然后分别写入代码
package com.yang.bean;
public class User {
private Integer uid;
private String username;
private String password;
private String phone;
private String address;
public Integer getUid() {
return uid;
}
public void setUid(Integer uid) {
this.uid = uid;
}
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;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
@Override
public String toString() {
return "User{" +
"uid=" + uid +
", username='" + username + '\'' +
", password='" + password + '\'' +
", phone='" + phone + '\'' +
", address='" + address + '\'' +
'}';
}
}
package com.yang.dao.impl;
import com.yang.bean.User;
import com.yang.dao.UserDao;
import com.yang.util.JDBCutil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class UserDaoImpl implements UserDao {
public Connection connection =null;
PreparedStatement pstm=null;
ResultSet rs=null;
User login=null;
private int row;
@Override
public User login(String username, String password) {
try {
connection=JDBCutil.connection();
String sql="select * from t_user where username=? and password=?";
pstm = connection.prepareStatement(sql);
pstm.setObject(1,username);
pstm.setObject(2,password);
rs = pstm.executeQuery();
if (rs.next()){
login=new User();
int uid=rs.getInt("uid");
login.setUid(uid);
login.setUsername(rs.getString("username&#