JAVA web课堂测试1

1登录账号：要求由6到12位字母、数字、下划线组成，只有字母可以开头；（1分）
2登录密码：要求显示“• ”或“*”表示输入位数，密码要求八位以上字母、数字组成。（1分）
3性别：要求用单选框或下拉框实现，选项只有“男”或“女”；（1分）
4学号：要求八位数字组成，前四位为“2018”开头，输入自己学号；（1分）
5姓名：输入自己的姓名；
5电子邮箱：要求判断正确格式；（1分）
6点击“添加”按钮，将学生个人信息存储到数据库中。（3分）
7可以演示连接上数据库。（2分）

源代码：

数据库的连接与关闭

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

public class shujuku 
{
    
    //数据库URL和账号密码
            public static final String connectionURL="jdbc:mysql://localhost:3306/student1?useUnicode=true&characterEncoding=GB18030&useSSL=false&serverTimezone=GMT&allowPublicKeyRetrieval=true";
            public static final String username="root";
            public static final String password="123456";
            
            //数据库连接
            public static Connection getConnection()
            {
                try {
                    Class.forName("com.mysql.cj.jdbc.Driver");
                    //Class.forName("com.mysql.cj.jdbc.Driver");
                    return DriverManager.getConnection(connectionURL, username, password);
                } catch (Exception e) {
                    // TODO: handle exception
                    System.out.println("数据库连接失败");
                    e.printStackTrace();
                }
                return null;
            }
            
            
            public static boolean getUsername(String username)
            {
                Connection connection=null;
                PreparedStatement preparedStatement=null;
                ResultSet rSet=null;
                try {
                    connection=getConnection();
                    String sql="select * from new_table where name="+"\‘"+username+"\‘";
                    System.out.println(sql);
                    preparedStatement=connection.prepareStatement(sql);
                    rSet=preparedStatement.executeQuery();
                    if(rSet.next())
                    {
                        System.out.println(rSet.getString(1));
                        return true;
                    }
                    else
                        return false;
                }
                catch(SQLException e)
                {
                    e.printStackTrace();
                }
                return false;
            }

            public static boolean Signin(String ID,String mima,String sex,String name,String xuehao,String Email,String college,String major,String Class,String year,String place,String beizhu)//写表只改这个函数
            {
                Connection con=null;
                PreparedStatement pstmt=null;
                try {
                    con=getConnection();
                    String sql="insert into student1 (ID,mima,sex,name,xuehao,Email,college,major,Class,year,place,beizhu) values (\‘"+ID+"\‘,\‘"+mima+"\‘,\‘"+sex+"\‘,\‘"+name+"\‘,\‘"+xuehao+"\‘,\‘"+Email+"\‘,\‘"+college+"\‘,\‘"+major+"\‘,\‘"+Class+"\‘,\‘"+year+"\‘,\‘"+place+"\‘,\‘"+beizhu+"\‘)";
                    System.out.println(sql);
                    pstmt=con.prepareStatement(sql);
                    pstmt.executeUpdate();
                    return true;
                }
                catch(SQLException e)
                {
                    e.printStackTrace();
                }
                return false;
            }

            public static boolean addInformation(String username,String password,String sex,String name,String id,String email,String agency,String major,String classnum,String year,String birthplace,String text)
            {
                
                Connection con=null;
                PreparedStatement pstmt=null;
                try {
                    con=getConnection();
                    String sql="insert into student1 (ID,mima,sex,name,xuehao,Email,college,major,Class,year,place,beizhu) values (\‘"+
                            username+"\‘,\‘"+password+"\‘,\‘"+sex+"\‘,\‘"+name+"\‘,\‘"+id+"\‘,\‘"+email+"\‘,\‘"+agency+"\‘,\‘"+major+"\‘,\‘"+classnum+"\‘,\‘"+year+"\‘,\‘"+birthplace+"\‘,\‘"+text+"\‘)";
                    System.out.println(sql);
                    pstmt=con.prepareStatement(sql);
                    pstmt.executeUpdate();
                    return true;
                }
                catch(SQLException e)
                {
                    e.printStackTrace();
                }
                return false;
                
            }

}

Selvlet

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.hjf.util.DBUtil;

/**
 * Servlet implementation class shuju
 */
@WebServlet("/shujuku")
public class shuju extends HttpServlet {
    private static final long serialVersionUID = 1L;
       
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
    
        
request.setCharacterEncoding("UTF-8");
        
        String username=request.getParameter("ID");
        String password=request.getParameter("mima");
        String sex=request.getParameter("sex");
        String name=request.getParameter("name");
        String id=request.getParameter("xuehao");
        String email=request.getParameter("Email");
        String agency=request.getParameter("college");
        String major=request.getParameter("major");
        String classnum=request.getParameter("Class");
        String year=request.getParameter("year");
        String birthplace=request.getParameter("place");
        String text=request.getParameter("beizhu");
        
        
        if(shujuku.addInformation(username,password,sex,name,id,email,agency,major,classnum,year,birthplace,text))
            response.sendRedirect("add.jsp?result=true");
        else
            response.sendRedirect("add.jsp?result=false");

    }

    /**
     * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
     */
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        // TODO Auto-generated method stub
        doGet(request, response);
    }

}

add.jsp

测试截图：