?? insert_secc.jsp
字號:
<%@page contentType="text/html; charset=GBK" errorPage="error.jsp" %>
<%@page import="java.sql.*"%>
<html>
<head>
<title>
insert_secc
</title>
</head>
<%! Connection conn;%>
<%! Statement stmt;%>
<%! ResultSet rs;%>
<%! String name,sex,age,address,xuehao,url,sql,sql2;%>
<%! int i;%>
<body bgcolor="#ffffff">
<%
xuehao=request.getParameter("xuehao").trim();
xuehao=new String(xuehao.getBytes("ISO-8859-1"));
name=request.getParameter("name").trim();
name=new String(name.getBytes("ISO-8859-1"));
sex=request.getParameter("sex").trim();
sex=new String(sex.getBytes("ISO-8859-1"));
age=request.getParameter("age").trim();
i=Integer.parseInt(age);
address=request.getParameter("address");
address=new String(address.getBytes("ISO-8859-1"));
if(xuehao.equals("")){
response.sendRedirect("error.jsp");
}
if(name.equals("")){
response.sendRedirect("error.jsp");
}
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:test");
stmt=conn.createStatement();
sql="select * from class where xuehao='"+xuehao+"'";
rs=stmt.executeQuery(sql);
if(rs.getRow()>0){
response.sendRedirect("error.jsp");
}
sql2="insert into class (xuehao,name,sex,age,address) values('"+xuehao+"','"+name+"','"+sex+"','"+i+"','"+address+"')";
stmt.executeUpdate(sql2);
out.print("正在處理信息,請稍后.............<meta http-equiv='refresh' content='2;url=index.jsp'>");
}catch(Exception e){
out.print(e);
}
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -