基于javaweb电子相册系统源码+数据库，ajax+jsp+servlet实现的电子相册

package com.album.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.album.entity.User; public class UserDao extends BaseDao{ //注册 public boolean add(String userName, String password, String nickName) { Connection con = super.getConnection(); PreparedStatement st = null; //用户名不可重复，先验证 if(!validation(userName, password)) { try { st = con.prepareStatement("insert into user(userName,password,nickName,regTime) values(?,?,?,?)"); st.setString(1, userName); st.setString(2, password); st.setString(3, nickName); st.setString(4, new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new java.util.Date())); int i = st.executeUpdate(); System.out.println(i+"行被修改。"); return true; } catch (SQLException e) { e.printStackTrace(); } } return false; } //登陆 public boolean validation(String userName, String password) { Connection con = super.getConnection(); PreparedStatement st = null; ResultSet rs = null; try { st = con.prepareStatement("select password from user where userName = ?"); st.setString(1, userName); rs = st.executeQuery(); if (rs.next()) { if (rs.getString("password").equals(password)) { return true; } } } catch (SQLException e) { e.printStackTrace(); } return false; } //查询 public User getUserByUserName(String userName) { Connection con = super.getConnection(); PreparedStatement st = null; ResultSet rs = null; try { st = con.prepareStatement("select * from user where userName = ?"); st.setString(1, userName); rs = st.executeQuery(); if (rs.next()) { User user = new User(); user.setUid(rs.getInt("uid")); user.setUserName(rs.getString("userName")); user.setPassword(rs.getString("password")); user.setNickName(rs.getString("nickName")); user.setRegTime(rs.getDate("regTime")); return user; } } catch (SQLException e) { e.printStackTrace(); } return null; } public User getUserById(int id) { Connection con = super.getConnection(); PreparedStatement st = null; ResultSet rs = null; try { st = con.prepareStatement("select * from user where uid = ?"); st.setInt(1, id); rs = st.executeQuery(); if (rs.next()) { User user = new User(); user.setUid(rs.getInt("uid")); user.setUserName(rs.getString("userName")); user.setPassword(rs.getString("password")); user.setNickName(rs.getString("nickName")); user.setRegTime(rs.getDate("regTime")); return user; } } catch (SQLException e) { e.printStackTrace(); } return null; } /*public static void main(String[] args) { UserDao ud = new UserDao(); System.out.println(ud.add("test2", "test2", "测试2")); }*/ }