jsp中输入的数据如何保存到数据库呢
日期：2014-05-17 浏览次数：20681 次
jsp中输入的数据怎么保存到数据库呢
<body>
<%
String number0 = request.getParameter("addnumber");
String name0 = request.getParameter("addname");
String birthday0 = request.getParameter("addbirthday");
String salary0 = request.getParameter("addsalary");
boolean flag = false;
%>
<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=java";
String user = "sa";
String password1 = "LGJwsj965397075";
Connection conn = DriverManager.getConnection(url, user, password1);
PreparedStatement s1 = null;
try {
String sql = "insert into employee values(?,?,?,?)";
s1 = conn.prepareStatement(sql);
s1.setString(1, number0);
s1.setString(1, name0);
s1.setString(1, birthday0);
s1.setString(1, salary0);
flag =s1.execute();
// 依次关闭
s1.close();
conn.close();
} catch (Exception e) {
}
%>
<%
if (flag) {
%>
<jsp:forward page="success.jsp" />
<%
}else{
%>
添加失败！！！！！！！！！！！！
<%
}
%>
</body>
总是不成功
------解决方案--------------------
s1.setString(1, number0);
s1.setString(1, name0);
s1.setString(1, birthday0);
s1.setString(1, salary0);
索引全是1？
------解决方案--------------------
s1.setString(1, number0);
s1.setString(2, name0);
s1.setString(3, birthday0);
s1.setString(4, salary0);
------解决方案--------------------
+1024
<body>
<%
String number0 = request.getParameter("addnumber");
String name0 = request.getParameter("addname");
String birthday0 = request.getParameter("addbirthday");
String salary0 = request.getParameter("addsalary");
boolean flag = false;
%>
<%
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String url = "jdbc:sqlserver://localhost:1433;DatabaseName=java";
String user = "sa";
String password1 = "LGJwsj965397075";
Connection conn = DriverManager.getConnection(url, user, password1);
PreparedStatement s1 = null;
try {
String sql = "insert into employee values(?,?,?,?)";
s1 = conn.prepareStatement(sql);
s1.setString(1, number0);
s1.setString(1, name0);
s1.setString(1, birthday0);
s1.setString(1, salary0);
flag =s1.execute();
// 依次关闭
s1.close();
conn.close();
} catch (Exception e) {
}
%>
<%
if (flag) {
%>
<jsp:forward page="success.jsp" />
<%
}else{
%>
添加失败！！！！！！！！！！！！
<%
}
%>
</body>
总是不成功
------解决方案--------------------
s1.setString(1, number0);
s1.setString(1, name0);
s1.setString(1, birthday0);
s1.setString(1, salary0);
索引全是1？
------解决方案--------------------
s1.setString(1, number0);
s1.setString(2, name0);
s1.setString(3, birthday0);
s1.setString(4, salary0);
------解决方案--------------------
+1024
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
