jsp java 网站带数据库的 宝宝空间

package cn.jmu.dao.impl; import java.sql.*; import javax.swing.*; import cn.jmu.vo.*; import cn.jmu.dbc.*; import cn.jmu.dao.*; import java.util.List; import java.util.ArrayList; //此类需要完成具体的数据库操作 public class PersonDAOImpl implements PersonDAO { //增加操作 public void insertDairy(String title, String context,String author) throws Exception { String sql="insert into dairyInfo(title,context,author) values(?,?,?)"; PreparedStatement pstmt=null; ConnectionManager dbc=null; //下面是针对数据库的具体操作 try { //连接数据库 dbc=new ConnectionManager(); pstmt=dbc.getConnection().prepareStatement(sql); pstmt.setString(1,title); pstmt.setString(2,context); pstmt.setString(3,author); //进行数据库更新操作 pstmt.executeUpdate(); Thread t = new Thread(new Runnable(){ public void run(){ // System.out.println("<script language='javascript'>alert('用户名重复，请重新填写');</script><a href='regist.jsp'>重新填写</a>"); JOptionPane.showMessageDialog(null, "发布成功！", "提示", JOptionPane.ERROR_MESSAGE); } }); t.start(); pstmt.close(); } catch (Exception e) { throw new Exception(e.getMessage()); } finally { //关闭数据库连接 } } public void insertGuest(String guestName, String context,String hostName) throws Exception { String sql="insert into guestInfo(guestName,context,hostName) values(?,?,?)"; PreparedStatement pstmt=null; ConnectionManager dbc=null; //下面是针对数据库的具体操作 try { //连接数据库 dbc=new ConnectionManager(); pstmt=dbc.getConnection().prepareStatement(sql); pstmt.setString(1,guestName); pstmt.setString(2,context); pstmt.setString(3,hostName); //进行数据库更新操作 pstmt.executeUpdate(); Thread t = new Thread(new Runnable(){ public void run(){ JOptionPane.showMessageDialog(null, "留言成功！", "提示", JOptionPane.ERROR_MESSAGE); } }); t.start(); pstmt.close(); } catch (Exception e) { throw new Exception(e.getMessage()); } finally { //关闭数据库连接 } } public void adminInsert(Person person) throws Exception { String sql="insert into userInfo(userName,userPwd) values(?,?)"; PreparedStatement pstmt=null; ConnectionManager dbc=null; //下面是针对数据库的具体操作 try { //连接数据库 dbc=new ConnectionManager(); pstmt=dbc.getConnection().prepareStatement(sql); pstmt.setString(1,person.getName()); pstmt.setString(2,person.getPassword()); //进行数据库更新操作 pstmt.executeUpdate(); Thread t = new Thread(new Runnable(){ public void run(){ // System.out.println("<script language='javascript'>alert('用户名重复，请重新填写');</script><a href='regist.jsp'>重新填写</a>"); JOptionPane.showMessageDialog(null, "注册成功！", "提示", JOptionPane.ERROR_MESSAGE); } }); t.start(); pstmt.close(); } catch (Exception e) { throw new Exception(e.getMessage()); } finally { //关闭数据库连接 } } public void insert(Person person) throws Exception { String sql="insert into userInfo(userName,userPwd) values(?,?)"; PreparedStatement pstmt=null; ConnectionManager dbc=null; //下面是针对数据库的具体操作 try { //连接数据库 dbc=new ConnectionManager(); pstmt=dbc.getConnection().prepareStatement(sql); pstmt.setString(1,person.getName()); pstmt.setString(2,person.getPassword()); //进行数据库更新操作 pstmt.executeUpdate(); Thread t = new Thread(new Runnable(){ public void run(){ // System.out.println("<script language='javascript'>alert('用户名重复，请重新填写');</script><a href='regist.jsp'>重新填写</a>"); JOptionPane.showMessageDialog(null, "注册成功！", "提示", JOptionPane.ERROR_MESSAGE); } }); t.start(); } catch (Exception e) { throw new Exception(e.getMessage()); } finally { //关闭数据库连接 } } public void regist(Person person) throws Exception { String sql1="SELECT userName,userPwd FROM userInfo WHERE userName=?"; PreparedStatement pstmt=null; ConnectionManager dbc=null; //下面是针对数据库的具体操作 try { //连接数据库 dbc=new ConnectionManager(); pstmt=dbc.getConnection().prepareStatement(sql1); pstmt.setString(1,person.getName()); //进行数据库更新操作 ResultSet rs=pstmt.executeQuery(); if(rs.next()){ Thread t = new Thread(new Runnable(){ public void run(){ // System.out.println("<script language='javascript'>alert('用户名重复，请重新填写');</script><a href='regist.jsp'>重新填写</a>"); JOptionPane.showMessageDialog(null, "用户名重复", "提示", JOptionPane.ERROR_MESSAGE); } }); t.start(); rs.close(); pstmt.close(); }else{ insert(person); } rs.close(); pstmt.close(); } catch (Exception e) { throw new Exception(e.getMessage()); } finally { //关闭数据库连接 dbc.close(); } } //更改操作 public void update(String name1,String name2) throws Exception { String sql="UPDATE userInfo SET userName=? WHERE userName=?"; PreparedStatement pstmt=null; ConnectionManager dbc=null; //下面是针对数据库的具体操作 try { //连接数据库 dbc=new ConnectionManager(); pstmt=dbc.getConnection().prepareStatement(sql); pstmt.setString(1,name1); pstmt.setString(2,name2); //进行数据库更新操作 pstmt.executeUpdate(); pstmt.close(); Thread t = new Thread(new Runnable(){ public void run(){ // System.out.println("<script language='javascript'>alert('用户名重复，请重新填写');</script><a href='regist.jsp'>重新填写</a>"); JOptionPane.showMessageDialog(null, "修改成功！", "提示", JOptionPane.ERROR_MESSAGE); } }); t.start(); } catch (Exception e) { throw new Exception("操作出现异常"); } finally { //关闭数据库连接 dbc.close(); } } //删除操作 public void deleteDairy(String title) throws Exception { String sql="DELETE FROM dairyInfo WHERE title=?"; PreparedStatement pstmt=null; ConnectionManager dbc=null; //下面是针对数据库的具体操作 try { //连接数据库 dbc=new ConnectionManager(); pstmt=dbc.getConnection().prepareStatement(sql); pstmt.setString(1,title); //进行数据库更新操作 pstmt.executeUpdate(); pstmt.close(); Thread t = new Thread(new Runnable(){ public void run(){ // System.out.println("<script language='javascript'>alert('用户名重复，请重新填写');</script><a href='regist.jsp'>重新填写</a>"); JOptionPane.showMessageDialog(null, "删除成功！", "提示", JOptionPane.ERROR_MESSAGE); } }); t.start(); } catch (Exception e) { throw new Exception("操作出现异常"); } finally { //关闭数据库连接 dbc.close(); } } public void delete(String name) throws Exception { String sql="DELETE FROM userInfo WHERE userName=?"; PreparedStatement pstmt=null; ConnectionManager dbc=null; //下面是针对数据库的具体操作 try { //连接数据库 dbc=new ConnectionManager(); pstmt=dbc.getConnection().prepareStatement(sql); pstmt.setString(1,name); //进行数据库更新操作 pstmt.executeUpdate(); pstmt.close(); Thread t