JSP-MySql 表的删增改查

如图：

主页：

<script type="text/javascript">
	function query(form1){
		createRequest("query.jsp?id="+form1.unique.value);		
	}
	function delete1(form1){
		createRequest("delete1.jsp?id="+form1.unique.value);		
	}
	function dateadd(form1){
		createRequest("dateadd.jsp?code="+form1.code.value+"&cname="+form1.cname.value+"&credit="+form1.credit.value);		
	}
	function update(form1){
		createRequest("update.jsp?code="+form1.code.value+"&cname="+form1.cname.value+"&credit="+form1.credit.value+"&id="+form1.unique.value);		
	}

查询

PreparedStatement pStmt = conn.prepareStatement("select * from t_course where id=?");
pStmt.setString(1,idnum);
ResultSet rs = pStmt.executeQuery();
while(rs.next()){
	out.println("id:" +rs.getString(1)+"\t课程代码:"+rs.getString(2)+"\t课程名称:"+rs.getString(3)+"\t学分:"+rs.getString(4));
}

删除

PreparedStatement pStmt = conn.prepareStatement("delete from t_course where id=?");
pStmt.setString(1,cid);
out.println("删除成功");
int rtn= pStmt.executeUpdate();
pStmt.close();

添加

PreparedStatement pStmt = conn.prepareStatement("insert into t_course (c_code,c_name,c_credit)values(?,?,?)");
pStmt.setString(1,code);
pStmt.setString(2,cname);
pStmt.setString(3,credit);
out.println("添加成功");
int rtn= pStmt.executeUpdate();
pStmt.close();

修改

PreparedStatement pStmt = conn.prepareStatement("update t_course set c_code=?,c_name=?,c_credit=?where id=?");
pStmt.setString(1,code);
pStmt.setString(2,cname);
pStmt.setString(3,credit);
pStmt.setString(4,cid);
out.println("修改成功");
int rtn= pStmt.executeUpdate();
pStmt.close();