dao:
package com.cn.song.DAO.Impl;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.cn.song.DAO.UserDao;
import com.cn.song.pojo.User;
import com.cn.song.util.ConnUtil;
public class UserDaoImpl implements UserDao {
public void add(User user) throws Exception {
Connection conn=ConnUtil.getConnecton();
PreparedStatement prep=
conn.prepareStatement("insert into user(name,password,email,school,sex,phone) values(?,?,?,?,?,?)");
prep.setString(1, user.getName());
prep.setString(2, user.getPassword());
prep.setString(3, user.getEmail());
prep.setString(4, user.getSchool());
prep.setString(5, user.getSex());
prep.setString(6, user.getPhone());
prep.executeUpdate();
ConnUtil.close(conn);
}
public User findByName(String name) throws Exception {
User user=null;
Connection conn=ConnUtil.getConnecton();
PreparedStatement prep=conn.prepareStatement
("select * from user where name='"+name+"'");
ResultSet rs=prep.executeQuery();
if(rs.next()){
user=new User();
user.setName(rs.getString("name"));
user.setPassword(rs.getString("password"));
user.setId(rs.getInt("id"));
user.setEmail(rs.getString("email"));
user.setPhone(rs.getString("phone"));
user.setSchool(rs.getString("school"));
user.setSex(rs.getString("sex"));
}
ConnUtil.close(conn);
return user;
}
}
pojo类:
package com.cn.song.pojo;
public class User {
private long id;
private String name;
private String email;
private String phone;
private String sex;
private String school;
private String password;
public String getPassword() {