<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>
总是不成功
<%
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>
总是不成功
解决方案 »
- Hibernate如何Hardcode数据库的用户名和密码
- Tomcat下Oracle驱动加载失败问题
- 救人啊!快死了!
- JXTA菜鸟学习求助~
- 急、struts2跳转问题,求大侠们帮助
- 求spring+mybatis 多数据源实例 [email protected]
- 如何在JSP中操作COOKIES?
- 用jcreator编译servlet,找不到包,是怎么解决的?
- Tomcat中的server.xml要修改的话要用什么打开?? 这个问题是不是很菜呀。 呵呵
- 关于page、include、plugin得比较问题?高手们帮帮忙
- 【100分求帮助!】关于程序在BAE上模拟HTTPS请求的问题
- 如何通过java 后台发送http请求(请求中有动提交脚本)?
s1.setString(1, name0);
s1.setString(1, birthday0);
s1.setString(1, salary0);
索引全是1?
s1.setString(2, name0);
s1.setString(3, birthday0);
s1.setString(4, salary0);