javaBean+Servlet+jsp的简单在线论坛

package com.lovobook; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; /** * 将用户名和密码与数据库中进行对比 * @author Administrator * */ public class CheckUserBean { public List list = null; public CheckUserBean() { } public boolean CheckUser(UserBean ub){ try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=cline", "sa", "sa"); PreparedStatement pst = con.prepareStatement("select * from LogInfo where ub_name='"+ub.getName()+"' and ub_pwd='"+ub.getPwd()+"'"); //Statement pst = con.createStatement(); ResultSet rs= pst.executeQuery(); while(rs.next()){ return true; } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return false; } /** * 添加用户 * @param rs * @return */ public boolean addUser(Register rs){ try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=cline", "sa", "sa"); PreparedStatement pst = con.prepareStatement("insert into LogInfo values(?,?)"); pst.setString(1, rs.getUsername().trim()); pst.setString(2, rs.getPassword().trim()); int i = pst.executeUpdate(); if(i==1){ return true; } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return false; } /** * 将留言信息添加到数据库 * @param ct * @return */ public boolean addCenter(Cntent ct){ try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=cline", "sa", "sa"); PreparedStatement pst = con.prepareStatement("insert into message values(?,?)"); pst.setString(1, ct.getTitle()); pst.setString(2, ct.getCenter()); int i = pst.executeUpdate(); if(i==1){ return true; } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return false; } public List QueryFall(){ list = new ArrayList(); try { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); Connection con = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=cline", "sa", "sa"); Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select * from message"); while(rs.next()){ Cntent ct = new Cntent(); ct.setTitle(rs.getString(2)); ct.setCenter(rs.getString(3)); list.add(ct); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return list; } }