jsp +sql 实现教评管理系统的增删改查
这里只拿学生管理在举例子,这个代码还有不完美的地方,待改进
- 添加 sadd.jsp 表单
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>数据库的添加</title>
<script type="text/javascript">
function check(){
if((form1.sno.value=="")||(form1.sname.value=="")||(form1.sdept.value=="")){
alert("用户名和密码不允许为空");
return;}
else
form1.submit()
}
</script>
</head>
<body>
<form action="sadd2.jsp" method="post" name="form1">
<h2 align="center">输入要添加的学生信息</h2>
<hr>
<table border="0" width="220" align="center">
<tr>
<td>学号:</td>
<td><input type="text" name="sno"></td>
</tr>
<tr>
<td>姓名:</td>
<td><input type="text" name="sname"></td>
</tr>
<tr>
<td>专业:</td>
<td><input type="text" name="sdept"></td>
</tr>
<tr>
<td>老师:</td>
<td><input type="text" name="steach"></td>
</tr>
<tr align="center">
<td colspan="2" align="center">
<input type="button" value="添加" onClick="check()">
<input name="clear" type="reset" value="清除">
</td>
</tr>
</table>
<hr><center>
<h3 align="center">如果不想添加学生请点击返回数据库</h3>
<a href="sshow.jsp">返回数据库</a> </center>
</form></body></html>
sadd2.jsp
<%@ page language="java" import="java.util.*,java.sql.*" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>添加学生</title>
</head>
<body>
<%
request.setCharacterEncoding("utf-8");
String sno = request.getParameter("sno");
String sname = request.getParameter("sname");
String sdept= request.getParameter("sdept");
String steach= request.getParameter("steach");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//桥接
Connection conn=DriverManager.getConnection("jdbc:odbc:DSSchool","sa","123456");
//连接数据库
String sql