==========================================================
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="db" scope="request" class="db.db_bean"></jsp:useBean><html><head>
<title>
default_pro
</title>
</head>
<body bgcolor="#ffffff"><%String s1=Request.getParameter("s1");
String s2=Request.getParameter("s2");
String s3=Request.getParameter("s3");
String t1=Request.getParameter("t1");
String s4=Request.getParameter("s4");
String s5=Request.getParameter("s5");
String t2=Request.getParameter("t2");
String s6=Request.getParameter("s6");
String s7=Request.getParameter("s7");
String s8=Request.getParameter("s8");
String s9=Request.getParameter("s9");
String s10=Request.getParameter("s10");
String t3=Request.getParameter("t3");
String t4=Request.getParameter("t4");
String t5=Request.getParameter("t5");
String t6=Request.getParameter("t6");
String t7=Request.getParameter("t7");
//取得数据库联接
Connection conn =db.getConn();
if(conn==null)
out.println("NULL");
//创建数据表的带参数插入语句
String insertSql = "insert into up(z_name,z_filesize,z_filelayout,z_software,z_size,z_size1,z_network,z_colour,z_colour1,z_slice,z_medicine,z_special,z_print,z_number,z_res,z_company,z_telephone,z_address,z_person) " + "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
System.out.println(insertSql);
//创建带3个参数的插入类
PreparedStatement insertPS = conn.prepareStatement(insertSql);
//设置插入类的3个参数
insertPS.setString(1, myFileName);
insertPS.setInt(2,fileSize);
insertPS.setString(3,s1);
insertPS.setString(4,s2);
insertPS.setString(5,s3);
insertPS.setString(6,t1);
insertPS.setString(7,s4);
insertPS.setString(8,s5);
insertPS.setString(9,t2);
insertPS.setString(10,s6);
insertPS.setString(11,s7);
insertPS.setString(12,s8);
insertPS.setString(13,s9);
insertPS.setString(14,s10);
insertPS.setString(15,t3);
insertPS.setString(16,t4);
insertPS.setString(17,t5);
insertPS.setString(18,t6);
insertPS.setString(19,t7);
try{
int rowCount = insertPS.executeUpdate();
out.println("成功插入记录" + rowCount + "条,如下所示:");
}catch(Exception ex){
out.println("Exception ->"+ex);
}
}
%></body>
</html>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="db" scope="request" class="db.db_bean"></jsp:useBean><html><head>
<title>
default_pro
</title>
</head>
<body bgcolor="#ffffff"><%String s1=Request.getParameter("s1");
String s2=Request.getParameter("s2");
String s3=Request.getParameter("s3");
String t1=Request.getParameter("t1");
String s4=Request.getParameter("s4");
String s5=Request.getParameter("s5");
String t2=Request.getParameter("t2");
String s6=Request.getParameter("s6");
String s7=Request.getParameter("s7");
String s8=Request.getParameter("s8");
String s9=Request.getParameter("s9");
String s10=Request.getParameter("s10");
String t3=Request.getParameter("t3");
String t4=Request.getParameter("t4");
String t5=Request.getParameter("t5");
String t6=Request.getParameter("t6");
String t7=Request.getParameter("t7");
//取得数据库联接
Connection conn =db.getConn();
if(conn==null)
out.println("NULL");
//创建数据表的带参数插入语句
String insertSql = "insert into up(z_name,z_filesize,z_filelayout,z_software,z_size,z_size1,z_network,z_colour,z_colour1,z_slice,z_medicine,z_special,z_print,z_number,z_res,z_company,z_telephone,z_address,z_person) " + "values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
System.out.println(insertSql);
//创建带3个参数的插入类
PreparedStatement insertPS = conn.prepareStatement(insertSql);
//设置插入类的3个参数
insertPS.setString(1, myFileName);
insertPS.setInt(2,fileSize);
insertPS.setString(3,s1);
insertPS.setString(4,s2);
insertPS.setString(5,s3);
insertPS.setString(6,t1);
insertPS.setString(7,s4);
insertPS.setString(8,s5);
insertPS.setString(9,t2);
insertPS.setString(10,s6);
insertPS.setString(11,s7);
insertPS.setString(12,s8);
insertPS.setString(13,s9);
insertPS.setString(14,s10);
insertPS.setString(15,t3);
insertPS.setString(16,t4);
insertPS.setString(17,t5);
insertPS.setString(18,t6);
insertPS.setString(19,t7);
try{
int rowCount = insertPS.executeUpdate();
out.println("成功插入记录" + rowCount + "条,如下所示:");
}catch(Exception ex){
out.println("Exception ->"+ex);
}
}
%></body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货