简易论坛制作

1.简易论坛制作
基本功能：登录，注册，修改登录用户信息，管理员修改用户，回帖，发帖。
下面上图：

点击注册用户的界面如下，验证均已写好（输入格式不正确，不能提交哦）

附上一张代码量截图：

采用典型的MVC模式编写，采用俩张mysql数据库表单，一张用于登录，一张用于存储发帖回帖信息。
数据库导入

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Dbcon {

public Connection getcon(){
        Connection conn = null;
try {
            Class.forName("com.mysql.jdbc.Driver");
            String url="jdbc:mysql://localhost:3306/luntan";
            String user="root";
            String pwd="mysql";
            conn=DriverManager.getConnection(url,user,pwd);
        } catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
        }
return conn;
    }

public void closeconn(){
        Connection con=getcon();
try {
if(!con.isClosed()){
                con.close();
            }
        } catch (SQLException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
public static void main(String[] args) {
// TODO Auto-generated method stub

// Dbcon db = new Dbcon();
// db.getcon();
// db.closeconn();
    }
}

将相关功能代码现在java文件中编写，主方法中测试，测试成功后在servlet中引用，在动态网页jsp中显示，用户登录注册代码如下：

package it.com.db;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import sun.security.timestamp.TSRequest;

import it.com.com.Dbcon;

public class UserDao {

public List<Map> findAll(){
        Dbcon db = new Dbcon();
        Connection con=db.getcon();
String sql ="SELECT * FROM users";
List<Map> list = new ArrayList<Map>();
        try {
            PreparedStatement pst=con.prepareStatement(sql);
ResultSet rs = pst.executeQuery();
while(rs.next()){
Map map = new HashMap();
map.put("userName", rs.getString("userName"));
map.put("userPwd", rs.getString("userPwd"));
map.put("Ename", rs.getString("Ename"));
map.put("Email", rs.getString("Email"));
map.put("Logo", rs.getString("Logo"));
list.add(map);
            }
        } catch (SQLException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
        }
return list;
    }

public void resiger(String userName,String userPwd,String Ename,String Email,String Logo){
        Dbcon db = new Dbcon();
        Connection con=db.getcon();
String sql="INSERT INTO users (userName,userPwd,Ename,Email,Logo) VALUES (?,?,?,?,?)";

        try {
            PreparedStatement pst = con.prepareStatement(sql);
            pst.setString(1,userName);
            pst.setString(2,userPwd);
            pst.setString(3,Ename);
            pst.setString(4,Email);
            pst.setString(5,Logo);

            pst.executeUpdate();
        } catch (SQLException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
        }

    }

public void update(String userName,String userPwd,String Ename,String Email,String Logo){
        Dbcon db = new Dbcon();
        Connection con=db.getcon();
String sql="UPDATE users SET userPwd=?,Ename=?,Email=?,Logo=? WHERE userName=? ";
        try {
            PreparedStatement pst=con.prepareStatement(sql);
            pst.setString(1, userPwd);
            pst.setString(2, Ename);
            pst.setString(3, Email);
            pst.setString(4, Logo);
            pst.setString(5, userName);
            pst.executeUpdate();
        } catch (SQLException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
        }
    }

public int pagesize(){
List<Map> list = findAll();
        int pagesize=list.size();
        int n=0;
if(pagesize%5==0){
            n=pagesize/5;
        }else{
            n=pagesize/5+1;
        }
return n;
    }

public int deleteByName(String userName){
        Dbcon db = new Dbcon();
        Connection con=db.getcon();
String sql="DELETE FROM users WHERE userName=?";
        int n=0;
        try {
            PreparedStatement pst=con.prepareStatement(sql);
            pst.setString(1, userName);
            pst.executeUpdate();
        } catch (SQLException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
            n=1;
        }
return n;
    }

public int login1(String username,String userpwd){
        Dbcon db = new Dbcon();
        Connection con=db.getcon();
String sql ="SELECT * FROM users WHERE userName=?";
        int n=0;
        try {
            PreparedStatement pst=con.prepareStatement(sql);
            pst.setString(1, username);
ResultSet rs = pst.executeQuery();
while(rs.next()){
                n=1;//如果找到则执行

if(rs.getString("userPwd").equals(userpwd)){
                    n=2;//密码正确
                }else{
                    n=3;//密码不正确
                }
            }
        } catch (SQLException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
        }
return n;
    }

public List<Map> select(String userName){
        Dbcon db = new Dbcon();
        Connection con=db.getcon();
List<Map> list =new ArrayList<Map>();
String sql="select * from users where userName=?";
        try {
            PreparedStatement pst=con.prepareStatement(sql);
            pst.setString(1, userName);
ResultSet rs = pst.executeQuery();
if(rs.next()){
Map map = new HashMap();
map.put("userName", rs.getString("userName"));
map.put("userPwd", rs.getString("userPwd"));
map.put("Ename", rs.getString("Ename"));
map.put("Email", rs.getString("Email"));
map.put("Logo", rs.getString("Logo"));
list.add(map);
            }
        } catch (SQLException e) {
// TODO Auto-generated catch block
            e.printStackTrace();
        }
return list;
    }

public static void main(String[] args) {
 // TODO Auto-generated method stub

 UserDao us = new UserDao();
// List<Map> list=us.findAll();
// for(Map map:list){
// System.out.println(map);
// }
 //us.update("x1", "xxx", "xxx", "xxx", "xxx");
 //us.deleteByName("rt");
 //us.resiger("asda", "sdad", "asda", "sdasd", "sdafdd", 221);
// List<Map>list1= us.select("rgt");
// for(Map map:list1){
// System.out.println(map);
// }
// 
 //us.resiger("x10", "xxx", "lala", "waa", "12");
 }
}