📄 thetianjia.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<HTML>
<BODY background="background.jpg" ><Font size=6>
<%!
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 account="",secret="";
if(session.isNew())
{
response.sendRedirect("login.jsp");
}
else
{ account=(String)session.getAttribute("account");
secret=(String)session.getAttribute("secret");
secret=codeToString(secret);
account=codeToString(account);
}
%>
<%
String sno=codeToString(request.getParameter("sno"));
if(sno==null)
{ sno=""; }
String name=codeToString(request.getParameter("name"));
if(name==null)
{ name=""; }
String sex=codeToString(request.getParameter("sex"));
if(sex==null)
{ sex=""; }
String classes=codeToString(request.getParameter("classes"));
if(classes==null)
{ classes=""; }
String gaoshu=codeToString(request.getParameter("gaoshu"));
if(gaoshu==null)
{ gaoshu=""; }
String C=codeToString(request.getParameter("Cyuyan"));
if(C==null)
{ C=""; }
String JAVA=codeToString(request.getParameter("JAVA"));
if(JAVA==null)
{ JAVA=""; }
String JSP=codeToString(request.getParameter("JSP"));
if(JSP==null)
{ JSP=""; }
Connection con;
Statement sql;
ResultSet rs;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:student");
sql=con.createStatement();
String condition=
"insert into student values"+"('"+sno+"','"+name+"','"+sex+"','"+classes+"','"+chinese+"','"+m+"','"+p+"','"+ch+"')";
sql.executeUpdate(condition);
con.close();
}
catch(SQLException event){}
%>
<P>添加新记录后的表：
<jsp:include page="suoyou.jsp" flush="true" />
</FONT>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -