📄 amend.jsp
字号:
<%@ page contentType="text/html; charset=iso8859_1" language="java" import="java.sql.*" errorPage="" session = "true" %>
<html >
<head>
<title>无标题文档</title>
</head>
<body>
<%
String ci2 = request.getParameter("couid");
String ci = request.getParameter("c_id");
String cn = request.getParameter("c_n");
String ch = request.getParameter("c_h");
String ct = request.getParameter("c_t");
String tea = request.getParameter("te");
String sta = request.getParameter("s_t");
String bw = request.getParameter("b_w");
String pe = request.getParameter("pe");
String ex = request.getParameter("ex_am");
//out.print(id);
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
con=DriverManager.getConnection("jdbc:mysql://localhost/jsp?user=root&password=123456&useUnicode=true&characterEncoding=iso8859_1");
sql=con.createStatement();
// sql.executeUpdate("insert into course value('" + ci + "','" + cn + "', " + ch + " , " + ct + " ,'" + tea + "','" + sta + "','" + bw + "'," + pe + " ,'" + ex +"')");
sql.executeUpdate("update course set course_id = '" + ci + "', course_name = '" +cn+ "', credit_hour =" + ch+ ", course_time =" +ct+", teacher_name = '" + tea + "', start_term ='" +sta+"', by_who ='" +bw+ "', people =" + pe +", exam='"+ ex+"' where course_id = '"+ci2+"'");
}
catch(Exception e)
{
out.print(e.getMessage());
}
%>
<jsp:forward page ="course_manage.jsp" />
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -