网上书店jsp简陋的原理源码

package dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Date; import bean.UserBean; public class UserDao { Connection con=(new BaseDao()).getConn(); public boolean selectUserByNameAndPass(String name,String pass) { boolean flag=false; String selectSql="select * from users where name=? and password=?"; try { PreparedStatement pst=con.prepareStatement(selectSql); pst.setString(1, name); pst.setString(2,pass); ResultSet rs=pst.executeQuery(); if(rs.next()) { flag=true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return flag; } public boolean selectUserByName(String name) { boolean flag=false; String selectSql="select * from users where name=?"; try { PreparedStatement pst=con.prepareStatement(selectSql); pst.setString(1, name); System.out.println(name); ResultSet rs=pst.executeQuery(); if(rs.next()) { flag=true; } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return flag; } public int insertToUser(UserBean user) { int count=0; String insertSql="insert into users values(?,?,?,?,?)"; try { PreparedStatement pst=con.prepareStatement(insertSql); pst.setString(1, user.getName()); pst.setString(2, user.getPassword()); pst.setInt(3, user.getSex()); pst.setString(4, user.getXueli()); java.sql.Date date=new java.sql.Date((new Date()).getTime()); pst.setDate(5,date ); count=pst.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return count; } }