<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <head> <title>用户登录界面</title> </head> <body> <div id="container"> <form action="putin.jsp" method="post" onSubmit="return check(this)"> <table bgcolor="yellow" border="5" cellpadding="5" cellspacing="20" style="margin: 10px auto; color: darkorange; border-collapse: collapse" align="center" width="320" > <tr> <th colspan=2>信息保存</th> </tr> <tr> <td align="center" style="color: orangered">课程名称 : </td> <td><input type="text" style="background-color: cornsilk" name="tclassname"/></td> </tr> <tr> <td align="center" style="color: orangered">任课教师 : </td> <td><input type="text" style="background-color: cornsilk" name="tteacher"/></td> </tr> <tr> <td align="center" style="color: orangered">上课地点 : </td> <td><input type="text" style="background-color: cornsilk" name="tplace"/></td> </tr> <%-- <tr> <th colspan=2><img src="yanzherngm.jsp"></th> </tr> --%> <tr align="center"> <td colspan="5"> <input type="submit" style="background-color: aqua" value="保存" /> </td> </tr> </table> </form> </div> </body> </html>
这是初次链接数据库操作里的登录界面，其需要输入的信息有三个，课程名称，任课教师和上课地点，分别是tclassname，tteacher，tplace。
<%@ page import="java.sql.Connection" %> <%@ page import="java.sql.DriverManager" %> <%@ page import="java.sql.Statement" %> <%@ page import="java.sql.PreparedStatement" %> <%@ page import="java.sql.*" %> <%@ page import="java.util.ArrayList" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <% String hey="录入信息有问题，请重新录入"; String tclassname=request.getParameter("tclassname"); String tteacher=request.getParameter("tteacher"); String tplace=request.getParameter("tplace"); try { //1.注册驱动 Class.forName("com.mysql.cj.jdbc.Driver"); // 2.使用我自己的数据库 test 获取链接 String url = "jdbc:mysql://localhost:3306/test"; String username = "root"; String password = "123456"; Connection connection = DriverManager.getConnection(url, username, password); //获取执行sql的对象statement Statement statement = connection.createStatement(); // SQL语句，使用我自己的test数据库下的 boss 表 String sqlsearch="select count(*) as ct from user where 课程名称= '"+tclassname+"'"; ResultSet re = statement.executeQuery(sqlsearch); re.next(); int count = re.getInt(1); if(count==0&&(tplace.indexOf("一教")!=-1||tplace.indexOf("二教")!=-1||tplace.indexOf("三教")!=-1||tplace.indexOf("基教")!=-1)) { hey = "保存成功"; String sql = "insert into user(课程名称,任课教师,上课地点) value (?,?,?)"; PreparedStatement pstmt; pstmt = connection.prepareStatement(sql); pstmt.setString(1, tclassname); pstmt.setString(2, tteacher); pstmt.setString(3, tplace); pstmt.executeUpdate(); connection.close(); } request.setAttribute("hey",hey); } catch (SQLException e) { } //ResultSet resultSet = statement.executeQuery(sql); //resultSet.close(); //statement.executeUpdate("delete from user where name='n'"); %> <html> <body> <div style="text-align: center" class="container text-center"> <h2 class="form-signin-heading" style="color: brown"> <font size=5> <strong> ${hey} </strong> </font> </h2> <form action="index.jsp"> <input type="submit" value="返回" style="color: darkblue;font-size:35px;background:khaki;border-radius: 15px" > </form> </div> </body> </html>
然后在这段代码里将输入的内容存入sql数据库下的表里，并对课程地点进行判断，若课程名称存在重复或地点里没有存在基教，一教二教三教等地点的话则认为输入有错误，需重新输入，反之则将内容存入自己的表中。
具体表如下：
