<%@include file="/common/sub_header.jsp"%>
<%@ page contentType="text/html;charset=UTF-8"
import="java.util.*,java.sql.*,com.db.*" pageEncoding="UTF-8"%>
<%
//添加用户
DBManager dbm = new DBManager();
String name = request.getParameter("name");
String rname = request.getParameter("rname");
String pwd = request.getParameter("pwd");
String sex = request.getParameter("sex");
String age = request.getParameter("age");
String tel = request.getParameter("tel");
String dept = request.getParameter("dept");
String zhi = request.getParameter("zhi");
String email = request.getParameter("email");
Statement stat = null;
Connection conn = null;
ResultSet rs = null;
stat = conn.createStatement();
String isExist = "select * from person where name ='" +name + "';";
rs = stat.executeQuery(isExist);
if (rs.next()) {
out.println("<script>alert('改工号已存在请重新输入');</script>");
}
else{String sql = "insert into person(name,pwd,sex,age,tel,type,rname,dept,zhi,email) values('"
+ name+ "','"+ pwd+ "','"+ sex+ "','"+ age+ "','"+ tel + "','员工','" + rname + "','" + dept + "','" + zhi + "','" + email + "')";
try {
conn = dbm.getConnection();
stat = conn.createStatement();
System.out.println(sql);
stat.execute(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
if (stat != null)
stat.close();
if (conn != null)
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}}
out.println("<script>alert('保存成功');window.location.href='list.jsp'</script>");
%>
解决方案 »
- JSP程序问题,求高手指导
- 求BaseDao中返回多行多列的返回值类型
- https协议下的打开文件怎样去掉下载对话框!
- jsp调用存储过程后分页数据显示不出来
- 请问重定向与跳转的区别?谢谢!!!
- 关于JSP操作文本文件的中文乱码的问题
- 如何将页面中查询出的结果输出到 Excel 中? 在线刷新狂等!!!
- javamail发送附件的问题,100分大放送!!!
- (●●●●,高分)在用jsp和mysql数据库中做的B/S构架中,如何在客户端读条形码?(急!在线等待)
- sql 語句中的轉義 , 非常困惑 .
- CAS获取company报错转换失败!
- struts2<s:form>标签的传session中的参数问题
ResultSet rs = null;
stat = conn.createStatement();
你这conn 是 null 一定会报错的
你还是别写代码了...。基础从头看起
<%@ page contentType="text/html;charset=UTF-8"
import="java.util.*,java.sql.*,com.db.*" pageEncoding="UTF-8"%>
<%
//添加用户
DBManager dbm = new DBManager();
String name = request.getParameter("name");
String rname = request.getParameter("rname");
String pwd = request.getParameter("pwd");
String sex = request.getParameter("sex");
String age = request.getParameter("age");
String tel = request.getParameter("tel");
String dept = request.getParameter("dept");
String zhi = request.getParameter("zhi");
String email = request.getParameter("email");
Statement stat = null;
Connection conn = null;
ResultSet rs = null;
try {
conn = dbm.getConnection();
stat = conn.createStatement();
String isExist = "select * from person where name ='" +name + "';";
rs = stat.executeQuery(isExist);
if (rs.next()) {
out.println("<script>alert('改工号已存在请重新输入');</script>");
} else{String sql = "insert into person(name,pwd,sex,age,tel,type,rname,dept,zhi,email) values('"
+ name+ "','"+ pwd+ "','"+ sex+ "','"+ age+ "','"+ tel + "','员工','" + rname + "','" + dept + "','" + zhi + "','" + email + "')";
System.out.println(sql);
stat.execute(sql);
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
if (stat != null)
stat.close();
if (conn != null)
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}}
out.println("<script>alert('保存成功');window.location.href='list.jsp'</script>");
%>
<%@ page contentType="text/html;charset=UTF-8"
import="java.util.*,java.sql.*,com.db.*" pageEncoding="UTF-8"%>
<%
//添加用户
DBManager dbm = new DBManager();
String name = request.getParameter("name");
String rname = request.getParameter("rname");
String pwd = request.getParameter("pwd");
String sex = request.getParameter("sex");
String age = request.getParameter("age");
String tel = request.getParameter("tel");
String dept = request.getParameter("dept");
String zhi = request.getParameter("zhi");
String email = request.getParameter("email");
Statement stat = null;
Connection conn = null;
ResultSet rs = null;
try {
conn = dbm.getConnection();
stat = conn.createStatement();
String isExist = "select * from person where name ='" + name
+ "';";
rs = stat.executeQuery(isExist);
if (rs.next()) {
out.println("<script>alert('改工号已存在请重新输入');</script>");
} else {
String sql = "insert into person(name,pwd,sex,age,tel,type,rname,dept,zhi,email) values('"
+ name
+ "','"
+ pwd
+ "','"
+ sex
+ "','"
+ age
+ "','"
+ tel
+ "','员工','"
+ rname
+ "','"
+ dept
+ "','" + zhi + "','" + email + "')";
System.out.println(sql);
stat.execute(sql);
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (stat != null)
stat.close();
if (conn != null)
conn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
out.println("<script>alert('保存成功');window.location.href='list.jsp'</script>");
%>