servlet+jsp+jdbc简单登录系统

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() {