📄 zenjia.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%!
public String codeToString(String str)
{//处理中文字符串的函数
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<%//接收客户端提交的数据
String kt_id=codeToString(request.getParameter("kt_id"));
if(kt_id==null)//无内容则设为空串
kt_id="";
String kt_class=codeToString(request.getParameter("kt_class"));
if(kt_class==null)//无内容则设为空串
kt_class="";
String kt_value=codeToString(request.getParameter("kt_value"));
if(kt_value==null)//无内容则设为空串
kt_value="";
String kt_difficulty=codeToString(request.getParameter("kt_difficulty"));
if(kt_difficulty==null)//无内容则设为空串
kt_difficulty="";
String kt_content=codeToString(request.getParameter("kt_content"));
if(kt_content==null)//无内容则设为空串
kt_content="";
String kt_option=codeToString(request.getParameter("kt_option"));
if(kt_option==null)//无内容则设为空串
kt_option="";
String kt_standard=codeToString(request.getParameter("kt_standard"));
if(kt_standard==null)//无内容则设为空串
kt_standard="";
%>
<%//构造追加记录SQL语句
String sqlString=null;//SQL语句
sqlString="insert into kaoti(kt_id,kt_class,kt_value,kt_difficulty,kt_content,kt_option,kt_standard)"+
" values('"+kt_id+"','"+kt_class+"','"+kt_value+"','"+kt_difficulty+"',"+kt_content+",'"+kt_option+"','"+kt_standard+"')";
%>
<%//执行SQL语句
try
{ Connection con;
Statement sql;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=kaoshi","sa","");
sql=con.createStatement();
sql.executeUpdate(sqlString);
con.close();
}
catch(SQLException e1)
{
out.print("SQL异常！");
}
%>
<head>
<title>用户注册程序</title>
</head>
<body>
<center>
<table border="1" width="700">
<tr>
<td width="100%" colspan="2" align="center">用户注册程序</td>
</tr>
<tr>
<td width="100%" colspan="2">追加用户成功！</td>
</tr>
</table>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -