javaweb入门

题目为   编写学生注册信息界面，并且连接到数据库

package com.ccc.servlet;

import java.io.IOException;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.ccc.business.ZhuceService;
import com.ccc.po.Zhuce;

public class ZhuceServlet extends HttpServlet {

    @Override
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        request.setCharacterEncoding("utf-8");//设置编码
        String param=request.getParameter("param");
        
        if("add".equals(param)) {
            String user=request.getParameter("user");
            String password=request.getParameter("password");
            String name=request.getParameter("name");
            String sex=request.getParameter("sex");
            String diqu=request.getParameter("diqu");
            String phone=request.getParameter("phone");
            String youxiang=request.getParameter("youxiang");
            Zhuce zhuce=new Zhuce(user,password,name,sex,diqu,phone,youxiang);
            ZhuceService zs=new ZhuceService();
            zs.saveZhuce(zhuce);
            System.out.println("连接servlet");
            //重定向到index.jsp
            response.sendRedirect("index.jsp");
            
        }
        if("delete".equals(param)) {
            String user = request.getParameter("user");
            
            ZhuceService.deleteZhuce(user);

            // 重定向到index.jspt页面
            response.sendRedirect("index.jsp");
        }
    }
    
}

package com.ccc.po;

public class Zhuce {
    private String user;
    private String password;
    private String name;
    private String sex;
    private String diqu;
    private String phone;
    private String youxiang;
    public Zhuce(String user,String password,String name,String sex,String diqu,String phone,String youxiang) {
        super();
        this.user=user;
        this.password=password;
        this.name=name;
        this.sex=sex;
        this.diqu=diqu;
        this.phone=phone;
        this.youxiang=youxiang;
    }
    public String getUser() {
        return user;
    }
    public void setUser(String user) {
        this.user = user;
    }
    public String getPassword() {
        return password;
    }
    public void setPassword(String password) {
        this.password = password;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }
    public String getDiqu() {
        return diqu;
    }
    public void setDiqu(String diqu) {
        this.diqu = diqu;
    }
    public String getPhone() {
        return phone;
    }
    public void setPhone(String phone) {
        this.phone = phone;
    }
    public String getYouxiang() {
        return youxiang;
    }
    public void setYouxiang(String youxiang) {
        this.youxiang = youxiang;
    }
    
}

package com.ccc.DButil;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

//数据库资源管理工具
public class DButil {

    private static Connection conn;
    private static Statement stmt;
    private static PreparedStatement pstmt;
    
    static {
        //加载驱动
        try {
            Class.forName("com.mysql.jdbc.Driver");
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
    
    //实例化数据库连接conn
    public static Connection getConnection() {
        try {
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/zhucebiao?useUnicode=true&characterEncoding=UTF-8", "root", "root");
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return conn;
    }
    
    //实例化SQL执行句柄stmt
    public static Statement getStatement() {
        Connection conn = getConnection();
        try {
            if(conn != null) {
                stmt = conn.createStatement();
            }
            
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return stmt;
    }
    
    //实例化SQL执行句柄pstmt
    public static PreparedStatement getPreparedStatement(String sql) {
        Connection conn = getConnection();
        try {
            if(conn != null) {
                pstmt = conn.prepareStatement(sql);
            }
        }catch(SQLException e) {
            e.printStackTrace();
        }
        return pstmt;
    }
    
    //关闭数据库连接资源
    public static void closeDBResources() {
        try {
            if(pstmt != null && !pstmt.isClosed()) {
                pstmt.close();
            }
            if(stmt != null && !stmt.isClosed()) {//如果stmt不为空，并且还未关闭
                stmt.close();
            }
            if(conn != null && !conn.isClosed()) {
                conn.close();
            }
        }catch(SQLException e) {
            e.printStackTrace();
        }
        
    }
    
}

package com.ccc.dao;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import com.ccc.DButil.DButil;

import com.ccc.po.Zhuce;



public class ZhuceDao {
    //保存信息
    public void saveZhuce(Zhuce zhuce) {
        String sql="insert into zhucebiaodan(user,password,name,sex,diqu,phone,youxiang)values(?,?,?,?,?,?,?)";
        PreparedStatement pstmt=DButil.getPreparedStatement(sql);
        //设置参数
        try {
            pstmt.setString(1, zhuce.getUser());
            pstmt.setString(2, zhuce.getPassword());
            pstmt.setString(3, zhuce.getName());
            pstmt.setString(4, zhuce.getSex());
            pstmt.setString(5, zhuce.getDiqu());
            pstmt.setString(6, zhuce.getPhone());
            pstmt.setString(7, zhuce.getYouxiang());
            pstmt.executeUpdate();//更新数据
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        
    }
    //删除学生
        public void deleteZhuce(String user) {
            String sql = "delete from zhucebiaodan where user = ? ";
            PreparedStatement pstmt = DButil.getPreparedStatement(sql);
            
            try {
                pstmt.setString(1, user);
                pstmt.executeUpdate();
                
            } catch (SQLException e) {
                
                e.printStackTrace();
            }finally {
                DButil.closeDBResources();
            }
        }
    //查询所有信息
            public static List<Zhuce> findAllZhuce() {
                List<Zhuce> zhucelist=new ArrayList<Zhuce>();
                String sql="select user,password,name,sex,diqu,phone,youxiang from zhucebiaodan ";
                PreparedStatement pstmt=DButil.getPreparedStatement(sql);
                //设置参数
                try {
                    ResultSet rs=pstmt.executeQuery();//执行得到结果集
                    while(rs.next()) {//每循环一次就找到一个学生
                        
                        String user=rs.getString("user");
                        String password=rs.getString("password");
                        String name=rs.getString("name");
                        String sex=rs.getString("sex");
                        String diqu=rs.getString("diqu");
                        String phone=rs.getString("phone");
                        String youxiang=rs.getString("youxiang");
                        Zhuce zhuce=new Zhuce(user,password,name,sex,diqu,phone,youxiang);
                        zhucelist.add(zhuce);//将找到的学生对象加到集合里面
                    }
                    rs.close();//关闭查询资源
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                finally {
                    //关闭资源
                    DButil.closeDBResources();
                }
                return zhucelist;
            }
        
}

package com.ccc.business;

import java.util.List;

import com.ccc.dao.ZhuceDao;
import com.ccc.po.Zhuce;


public class ZhuceService {
    private static ZhuceDao zhucedao=new ZhuceDao();
    //添加信息
        public  void saveZhuce(Zhuce zhuce) {
            zhucedao.saveZhuce(zhuce);
        }
        //查询所有信息
        public List<Zhuce> findAllZhuce(){
            return ZhuceDao.findAllZhuce();
        }
        //删除信息
        public static void deleteZhuce(String user) {
            zhucedao.deleteZhuce(user);
        }
}

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<script type="text/javascript">
function checkForm(){
    //根据input 的id找到四个控件  节点
    var userNode=document.getElementById("user");
    var passwordNode=document.getElementById("password");
    var nameNode=document.getElementById("name");
    var phoneNode=document.getElementById("phone");
    var youxiangNode=document.getElementById("youxiang");
    
    var regUser=/^[a-zA-Z]([a-zA-Z]|\d){5,11}$/;//纯数字1-10个 ^起始符  $末尾符
    var regPassword=/^([a-zA-Z]|\d){6}$/;

    var regPhone=/^\d{11}$/;
    var regYouxiang=/^\S+@\S+\.com$/;
    
    //判断user是否为空
    if(userNode.value.length==0){
        alert("用户名不能为空");
        return false;
    }
    if(!regUser.test(userNode.value)){
        alert("用户名必须以英文字母开头和数字组成的为6-12位字符");
        return false;
    }
    //判断password是否为空
    if(passwordNode.value.length==0){//将空格替换成长度为0
        alert("密码不能为空!");
        return false;
    }
    if(!regPassword.test(passwordNode.value)){//将空格替换成长度为0
        alert("密码为6位英文和数字组成");
        return false;
    }
    //判断name是否为空
    if(nameNode.value.length==0){
        alert("姓名不能为空");
        return false;
    }


    //判断phone是否为空
    if(phoneNode.value.length==0){
        alert("手机号不能为空");
        return false;
    }
    if(!regPhone.test(phoneNode.value)){
        alert("手机号必须为11位数字");
        return false;
    }
    //判断youxiang是否为空
    if(youxiangNode.value.length==0){
        alert("邮箱不能为空");
        return false;
    }
    if(!regYouxiang.test(youxiangNode.value)){
        alert("邮箱必须为邮箱格式");
        return false;
    }
    return true;
}        
</script>
<body>
    <h2>软件工程专业交流注册表</h2>
    <hr>                       
    <form action="ZhuceServlet?param=add"   method="post" onsubmit= "return checkForm();">
        <table width="400" border="0" align="center">
            <tr>
                <td>用户名：</td>
                <td><input type="text" id="user" name="user"></td>
            </tr>
            <tr>
                <td>密码：</td>
                <td><input type="password" id="password" name="password" ></td>
            </tr>
            <tr>
                <td>姓名：</td>   <!--输入只能为数字   正则表达式 -->
                <td><input type="text" id="name" name="name" ></td>
            </tr>
            <tr>
                <td>sex：</td>
                <td><input type="checkbox" id="sex" name="sex" value="Bike">男
                    <input type="checkbox" id="sex" name="sex" value="Car">女 </td>
            </tr>
            <tr>
                <td>地区：</td>
                <td><select id="diqu" name="diqu">
                        <option value="Volvo">Volvo</option>
                        <option value="Saab">Saab</option>
                        <option value="Fiat" selected>Fiat</option>
                        <option value="Audi">Audi</option>
                </select></td>
            </tr>
            <tr>
                <td>手机号：</td>
                <td><input type="text" id="phone" name="phone"></td>
            </tr>
            <tr>
                <td>邮箱：</td>
                <td><input type="text" id="youxiang" name="youxiang"></td>
            </tr>
            <tr>
                <td colspan="2">
                    <input type="submit" value="提交">
                    <input type="reset" value="重置">
                </td>
            </tr>
        </table>
    </form>
</body>
</html>