📄 indata.jsp

📁 实习的时候做的数字校园系统

💻 JSP

字号:




<%@ page import="java.sql.*"%>
<%@ page import="com.xxgl.data.DBconnection"%>

<%@ page language="java" contentType="text/html; charset=GBK"
    pageEncoding="GBK"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>Insert title here</title>
</head>
<body>
<% 
int count=0;
//以try开始
try
{ 
 //建一个数据库连接
Connection con = DBconnection.getConnection();
Statement stmt;
String sname =request.getParameter("sname");
sname=new String (sname.getBytes("ISO-8859-1"),"GBK");

int sex=Integer.parseInt(request.getParameter("sex"));
int age =Integer.parseInt(request.getParameter("age"));
int in_year=Integer.parseInt(request.getParameter("in_year"));

String jg =request.getParameter("jg");
jg=new String (jg.getBytes("ISO-8859-1"),"GBK");

String zzmm =request.getParameter("zzmm");
zzmm=new String (zzmm.getBytes("ISO-8859-1"),"GBK");

String adress =request.getParameter("adress");
adress=new String (adress.getBytes("ISO-8859-1"),"GBK");

String phone =request.getParameter("phone");
phone=new String (phone.getBytes("ISO-8859-1"),"GBK");

//String yesorno =request.getParameter("yesorno");
String memory =request.getParameter("memory");
memory=new String (memory.getBytes("ISO-8859-1"),"GBK");


//创建一个JDBC声明
stmt = con.createStatement();
//增加新记录
String tempStr="'"+sname+"','"+sex+"','"+age+"','"+in_year+"','"+jg+"','"+zzmm+"','"+adress+"','"+phone+"','"+memory+"'";
String sql="INSERT INTO newstudent (s_name,sex,age,in_year,jg,zzmm,adress,phone,memory) VALUES ("+tempStr+")";
count=stmt.executeUpdate(sql);
//关闭数据库连结
stmt.close();
con.close();
}

//捕获错误信息
catch (Exception e) {out.println(e.getMessage());}

 %>
<script language="javascript">
if(<%=count%>==1)
alert("添加成功！");
else
alert("添加失败");
window.location.href("addnewstudent.html");
</script>



</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -