📄 addok.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
pageEncoding="gb2312"%>
<html>
<head><title>添加</title><head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<body>
<hr>
<h4>信息：</h4>
<%@ page import="java.sql.*"%>
<%
try{
request.setCharacterEncoding("gb2312");
int id=Integer.parseInt(request.getParameter("id"));
String str;
String datauser="root";
String datapw="L0VEXING";
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/luyou?user="+datauser+"&password="+datapw+"&useUnicode=true&characterEncoding=GB2312" ;
Connection con= DriverManager.getConnection(url);
Statement sm=con.createStatement();
switch (id)
{
case 1:
String jieshao=request.getParameter("jieshao");
String address=request.getParameter("address");
String Timer=request.getParameter("Timer");
int money=Integer.parseInt(request.getParameter("money"));
str="insert into jd values(NULL,'"+jieshao+"','"+address+"','"+Timer+"',"+money+")";
sm.executeUpdate(str);
out.print("<center><h3>添加景点成功</h3></center>");
break;
case 2:
String anpai=request.getParameter("anpai");
String ssjt=request.getParameter("ssjt");
int money1=Integer.parseInt(request.getParameter("money"));
String lx=request.getParameter("lx");
str="insert into lx values(NULL,'"+anpai+"','"+ssjt+"',"+money1+",'"+lx+"')";
sm.executeUpdate(str);
out.print("<center><h3>添加路线成功</h3></center>");
break;
}
sm.close();
con.close();
}
catch(Exception e)
{
out.print("未知错误，请联系管理员");
}
%>
<hr>
<table width="100%" border="0" cellpadding="0" align="center">
<tr>
<td align="center"><a href="index.html" title="返回">返回</a></td>
</tr></table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -