<body>
<a href="ch6/add.jsp">新增记录</a><br>
<a href="ch6/upd.jsp">更改记录</a><br>
<a href="ch6/sel.jsp">查找记录</a><br>
<a href="ch6/del.jsp">删除记录</a><br>
<form action="ch6/par.jsp" method="post">
学号<input type="text" name="xh">
姓名:<input type="text" name="xm">
<input type="submit" value="提交">
</form>
</body>
add。jsp
```java
<%
String driverClass="com.mysql.cj.jdbc.Driver";
String serverIp="localhost";
String databaseName="my";
String username="root";
String password="zp1536338";
String url="jdbc:mysql://localhost:3306/my?useSSL=false&serverTimezone=UTC";
Class.forName(driverClass);
Connection conn = DriverManager.getConnection(url, username, password);
if(conn != null){
String sql ="insert into student(stuno,stuname) values('2017117191','刘备')";
Statement stmt= conn.createStatement();
int result = stmt.executeUpdate(sql);
if(result >0){
System.out.print("插入数据成功");
}else{
System.out.print("插入数据失败");
}
}else{
System.out.println("连接失败");
}
conn.close();
%>
<p>ok</p>
<%
String strHtml="";
String driverClass="com.mysql.cj.jdbc.Driver";
String serverIp="localhost";
String databaseName="my";
String username="root";
String password="zp1536338";
String url="jdbc:mysql://localhost:3306/my?useSSL=false&serverTimezone=UTC";
Class.forName(driverClass);
Connection conn = DriverManager.getConnection(url, username, password);
if(conn != null){
String sql =" select * from student";
Statement stmt= conn.createStatement();
ResultSet result= stmt.executeQuery(sql);
while(result.next()){
strHtml += result.getInt("id") +" | "+ result.getString(2) +" | " + result.getString(3);
strHtml +="<br>";
}
}else{
System.out.println("连接失败");
}
conn.close();
%>
<%= strHtml %>
</body>