WebRoot/admin/crouse-add2.jsp

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ page contentType="text/html; charset=utf-8" import="java.sql.*"%>
<html>
<head>
<title>管理员页面</title>
</head>
<body>
<br><br><br>

<% 
request.setCharacterEncoding("utf-8");
String id=request.getParameter("id");
String name=request.getParameter("name");
String classid=request.getParameter("classid");
String classname=request.getParameter("classname");
String techid=request.getParameter("techid");
String techname=request.getParameter("techname");

String user="root";
String password="root";
String url="jdbc:mysql://localhost:3306/JSFP";

Class.forName("com.mysql.jdbc.Driver");
Connection conn=DriverManager.getConnection(url,user,password);
Statement state=conn.createStatement();

String sqlq="select * from course where cr_id='"+id+"'";
ResultSet rs=null;
rs=state.executeQuery(sqlq);
if(!rs.next()){
String sql="insert into course (cr_id,cr_name,class_id,class_name,tech_id,tech_name) values('"+id+"','"+name+"','"+classid+"','"+classname+"', '"+techid+"','"+techname+"')";
int i=state.executeUpdate(sql);
if(i==1){
%>
<div align=center>
<h2>信息添加成功！</h2>
<% }else{
%>
<h2>信息添加失败！</h2>
<% }
}
else{
%>
<h2>信息已存在，不得添加！</h2>
</div>
<%
}
state.close();
rs.close();
 
 %>
 
 </body>
 </html>