2019.10.21数据库连接

package shujukulei;


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

public class caozuoshujuku 
{
    
    //数据库URL和账号密码
            public static final String connectionURL="jdbc:mysql://localhost:3306/sys?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 zhanghao,String mima,String sex,String name,String xuehao,String email,String xueyuan,String xi,String banji,String year,String place,String beizhu)//写表只改这个函数
            {
                Connection con=null;
                PreparedStatement pstmt=null;
                try {
                    con=getConnection();
                    String sql="insert into addstudent (zhanghao,mima,sex,name,xuehao,email,xueyuan,xi,banji,year,place,beizhu) values (\'"+zhanghao+"\',\'"+mima+"\',\'"+sex+"\',\'"+name+"\',\'"+xuehao+"\',\'"+email+"\',\'"+xueyuan+"\',\'"+xi+"\',\'"+banji+"\',\'"+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 addstudent (zhanghao,mima,sex,name,xuehao,email,xueyuan,xi,banji,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;
                
            }

            
            
            public static void main(String[] args) {
                addInformation("1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1", "1");
            }



}

package shujukulei;

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 sjk
 */
@WebServlet("/sjk")
public class sjk 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("zhanghao");
        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("xueyuan");
        String major=request.getParameter("xi");
        String classnum=request.getParameter("banji");
        String year=request.getParameter("year");
        String birthplace=request.getParameter("place");
        String text=request.getParameter("beizhu");
        
        if(caozuoshujuku.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);
    }
    
    

}

<%@ 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>
<style > 
    
    .a{
        margin-top: 20px;
    }
    .b{
        font-size: 20px;
        width: 160px;
        color: white;
        background-color: greenyellow;
    }
</style>
</head>
<body  onload="getResult()">
    
    <div align="center">
        <h1 style="color: red;">当前位置：添加学生信息</h1>
        
        <br> 
        <form action="sjk" method="post" >
            <div class="a">
                登录账号：<input type="text" id="zhanghao" name="zhanghao"/>
                
            </div>
            <div class="a">
                登录密码：<input type="password" id="mima" datatype="*8-16" nullmsg="请输入8-16位密码！" name="mima" />
            </div>
            <div class="a">
                性别：<select>
                <option value="volvo">Volvo</option>
                <option value="男">男</option>
                <option value="女">女</option>
                </select>
            </div>
            <div class="a">
                姓名：<input type="text" id="name" name="name" />
            </div>
            <div class="a">
                学号：<input type="text" id="xuehao" name="xuehao" />
            </div>
            
            <div class="a">
                电子邮箱：<input type="text" id="email" name="email" />
            </div>
            <div class="a">
                所在学院：<input type="text" id="xueyuan" name="xueyuan" />
            </div>
            <div class="a">
                所在系：<input type="text" id="xi" name="xi" />
            </div>
            <div class="a">
                所在班级：<input type="text" id="banji" name="banji" />
            </div>
            
            <div class="a">
                入学年份：<select>
                <option value="volvo">Volvo</option>
                <option value="1998">1998</option>
                <option value="1999">1999</option>
                <option value="2000">2000</option>
                <option value="2001">2001</option>
                <option value="2002">2002</option>
                <option value="2003">2003</option>
                <option value="2004">2005</option>
                <option value="2006">2007</option>
                <option value="2008">2008</option>
                </select>
            </div>
            <div class="a">
                生源地：<input type="text" id="place" name="place" />
            </div>
            
            <div class="a">
                备注：<input type="text" id="beizhu" name="beizhu" />
            </div>
            
            <div class="a">
                <input type="submit" value="添加" onclick="return check()">
            </div>
            
            
        </form>
    </div>
    
    <script type="text/javascript">
    
    function GetQueryString(name) { 
          var reg = new RegExp("(^|&)" + name + "=([^&]*)(&|$)", "i"); 
          var r = window.location.search.substr(1).match(reg); //获取url中"?"符后的字符串并正则匹配
          var context = ""; 
          if (r != null) 
             context = r[2]; 
          reg = null; 
          r = null; 
          return context == null || context == "" || context == "undefined" ? "" : context; 
    }
function getResult()
    {
        if(GetQueryString("result")=="true")
            alert("添加成功！");
        else if(GetQueryString("result")=="false")
            alert("添加失败！");
    }

    

function check() {
    var username = document.getElementById("zhanghao");
    var password = document.getElementById("mima");
    var xh = document.getElementById("xuehao");
    var email = document.getElementById("email");
    var name = document.getElementById("name");
    if (!username.value.match(/^[a-zA-Z]\w{5,11}$/)) {                   
        alert("用户名由六到十二英文字符和数字组成，以英文字母开头");                
        username.focus();
        return false;
}    
     else if (!password.value.match(/^[A-Za-z0-9]\w{7,20}$/)) {           
     alert(" 密码由八 位 以上英文 和数 字 组成");         
     password.focus();
     return false;
}
     else if(name.value!="杨一帆")
        {
        alert("姓名错误");
        name.focus;
        return false;
        }
    else if(xh.value<"20180000"|| xh.value>"20189999")
        {
         alert(" 学号由2018开头的八位组成");                
         xh.focus();
         return false;
        }        
    else if (!email.value.match(/^[a-z0-9]+([._\\-]*[a-z0-9])*@([a-z0-9]+[-a-z0-9]*[a-z0-9]+.){1,63}[a-z0-9]+$/)) {
     alert(" 邮箱格式错误");
     email.focus();
     return false;
}
} 

</script>

        
        
        
    </script>
</body>
</html>

今天的测试，主要是是连接上数据库，然后设计网页，在做一个表格，最主要的是连接数据库，这个对我来说是比较困难的，我找学长帮助我，然后连接成功后，在百度上面查找题目上面的要求，花费了较长的时间，在课下还得巩固和复习，对数据库的连接熟习掌握。