基于javaweb+mysql的jsp+servlet零食商城系统(java+jsp+javascript+servlet+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的JSP+Servlet零食商城系统(java+jsp+javascript+servlet+mysql)
项目介绍
本项目分前后台,共有管理员、卖家、买家三种角色; 前台主要功能包括: 首页、商城介绍、商品一览、打折专区、销售排行、成交记录、商城资讯、联系我们、留言板等功能;
管理员主要功能包括: 交易信息查看:进行中的订单、历史订单; 网站信息查看与编辑:商城介绍、商城资讯、广告图片、联系我们、商城公告、留言板、友情链接等; 基础信息查看与编辑:买家会员、卖家会员、商品管理、商品评价管理、商品属性设置; 系统管理:添加管理员、管理员维护; 个人信息:基本资料管理、修改登录密码;
卖家主要功能包括: 交易信息查看:查看订单、历史订单; 商品管理:添加商品、商品管理; 商铺信息:基本资料管理、修改登录密码;
买家主要功能包括: 登录前台、买家中心、交易信息查看(查看订单、历史订单、购物车)、个人信息;
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本; 6.是否Maven项目:否;
技术栈
- 后端:Servlet 2. 前端:JSP+CSS+JavaScript+ajax
使用说明
- 使用Navicat或者其它工具,在mysql中创建对应名称的数据库,并导入项目的sql文件; 2. 使用IDEA/Eclipse/MyEclipse导入项目,Eclipse/MyEclipse导入时,若为maven项目请选择maven; 若为maven项目,导入成功后请执行maven clean;maven install命令,然后运行; 3. 将项目中dbconnection.properties配置文件中的数据库配置改为自己的配置; 4. 运行项目,输入http://localhost:8080/foodemarket 登录
}
public HashMap getmap(String id, String table) {
List<HashMap> list = new ArrayList();
try {
Statement st = conn.createStatement();
System.out.println("select * from " + table + " where id=" + id);
ResultSet rs = st.executeQuery("select * from " + table + " where id=" + id);
ResultSetMetaData rsmd = rs.getMetaData();
while (rs.next()) {
HashMap map = new HashMap();
int i = rsmd.getColumnCount();
for (int j = 1; j <= i; j++) {
if (!rsmd.getColumnName(j).equals("ID")) {
String str = rs.getString(j) == null ? "" : rs.getString(j);
if (str.equals("null"))
str = "";
map.put(rsmd.getColumnName(j), str);
} else
map.put("id", rs.getString(j));
}
list.add(map);
}
rs.close();
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return list.get(0);
}
public static void main(String[] args) {
Connection conn2 = new CommDAO().getConn();
System.out.println(conn2);
}
public String insert(HttpServletRequest request, HttpServletResponse response, String tablename, HashMap extmap,
boolean alert, boolean reflush) {
extmap.put("savetime", Info.getDateStr());
if (request.getParameter("f") != null) {
HashMap typemap = new HashMap();
ArrayList<String> collist = new ArrayList();
String sql = "insert into " + tablename + "(";
Connection conn = this.getConn();
try {
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from " + tablename);
ResultSetMetaData rsmd = rs.getMetaData();
int i = rsmd.getColumnCount();
System.out.println(i);
for (int j = 1; j <= i; j++) {
WritableSheet ws = wwb.createSheet("sheet1", 0);
ws.setColumnView(0, 20);
ws.setColumnView(1, 20);
ws.setColumnView(2, 20);
ws.setColumnView(3, 20);
ws.setColumnView(4, 20);
ws.setColumnView(5, 20);
try {
for (int i = 0; i < pros.length; i++) {
Label label1 = new Label(i, 0, "");
label1.setString(pros[i]);
ws.addCell(label1);
}
} catch (RowsExceededException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
} catch (WriteException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
//下面开始添加单元格
int i = 1;
for (List t : list) {
try {
Iterator it = t.iterator();
int jj = 0;
while (it.hasNext()) {
Label label1 = new Label(jj, i, "");
String a = it.next().toString();
label1.setString(a);
ws.addCell(label1);
jj++;
}
i++;
try {
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("select * from " + tablename);
ResultSetMetaData rsmd = rs.getMetaData();
int i = rsmd.getColumnCount();
System.out.println(i);
for (int j = 1; j <= i; j++) {
if (rsmd.getColumnName(j).equals("id"))
continue;
typemap.put(rsmd.getColumnName(j) + "---", rsmd.getColumnTypeName(j));
collist.add(rsmd.getColumnName(j));
if (names.indexOf("," + rsmd.getColumnName(j) + ",") > -1) {
String[] values = request.getParameterValues(rsmd.getColumnName(j));
String value = "";
for (String vstr : values) {
if (vstr == null)
vstr = "";
if (vstr.equals("null"))
vstr = "";
value += vstr + "-";
}
if (value == null)
value = "";
if (value.equals("null"))
value = "";
if (value.length() > 0)
value = value.substring(0, value.length() - 1);
if (rsmd.getColumnTypeName(j).equals("int")) {
sql += rsmd.getColumnName(j) + "=" + value + ",";
} else {
sql += rsmd.getColumnName(j) + "='" + value + "',";
}
} else {
if (extmap.get(rsmd.getColumnName(j)) != null) {
if (rsmd.getColumnTypeName(j).equals("int")) {
sql += rsmd.getColumnName(j) + "=" + extmap.get(rsmd.getColumnName(j)) + ",";
} else {
sql += rsmd.getColumnName(j) + "='" + extmap.get(rsmd.getColumnName(j)) + "',";
}
}
}
}
sql = sql.substring(0, sql.length() - 1);
sql += " where id=" + request.getParameter("id");
System.out.println(sql);
config.load(in);
url = config.getProperty("dburl");
userName = config.getProperty("dbusername");
password = config.getProperty("dbpassword");
in.close();
} catch (Exception e) {
e.printStackTrace();
}
}
Connection conn = null;
public Connection getConn() {
try {
String d = new Date().toLocaleString().substring(0, 9);
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection(
url, userName,
password);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
public CommDAO() {
conn = this.getConn();
}
// 该方法返回一个table 用于流动图片
public String DynamicImage(String categoryid, int cut, int width, int height) {
StringBuffer imgStr = new StringBuffer();
StringBuffer thePics1 = new StringBuffer();
StringBuffer theLinks1 = new StringBuffer();
StringBuffer theTexts1 = new StringBuffer();
request.setAttribute("suc", "");
go("/admin/uppass.jsp", request, response);
}
if(ac.equals("addjsy"))
{
String xinmin=request.getParameter("xinmin");
String gonghao=request.getParameter("gonghao");
String filename=request.getParameter("filename");
String xinbie=request.getParameter("xinbie");
String xueli=request.getParameter("xueli");
String senri=request.getParameter("senri");
String jiguan=request.getParameter("jiguan");
String dianhua=request.getParameter("dianhua");
String souji=request.getParameter("souji");
String sql = "insert into yudiinfo values('"+xinmin+"','"+gonghao+"','"+filename+"','"+xinbie+"','"+xueli+"','"+senri+"','"+jiguan+"','场馆','"+souji+"')";
HashMap extmap = new HashMap();
extmap.put("dianhua", "场馆");
dao.insert(request,response, "yudiinfo", extmap, false, false);
request.setAttribute("suc", "");
go("/admin/jsydj.jsp", request, response);
}
if(ac.equals("updatejsy"))
{
String id = request.getParameter("id");
String xinmin=request.getParameter("xinmin");
String gonghao=request.getParameter("gonghao");
String filename=request.getParameter("filename");
String xinbie=request.getParameter("xinbie");
String xueli=request.getParameter("xueli");
String senri=request.getParameter("senri");
String jiguan=request.getParameter("jiguan");
String dianhua=request.getParameter("dianhua");
String souji=request.getParameter("souji");
String sql = "update yudiinfo set xinmin='"+xinmin+"',gonghao='"+gonghao+"',filename='"+filename+"',xinbie='"+xinbie+"',xueli='"+xueli+"',senri='"+senri+"',jiguan='"+jiguan+"',dianhua='"+dianhua+"',souji='"+souji+"' where id="+id;
dao.commOper(sql);
request.setAttribute("suc", "");
request.setAttribute("suc", "");
go("/admin/jsydj.jsp", request, response);
}
if(ac.equals("addwzjl"))
{
String cheph = request.getParameter("cheph");
String weizxm = request.getParameter("weizxm");
String weizdz = request.getParameter("weizdz");
String jiasy = request.getParameter("jiasy");
String weizsj = request.getParameter("weizsj");
String fakje = request.getParameter("fakje");
String bei = request.getParameter("bei");
String sql="insert into wzinfo values( '"+cheph+"'," +
"'"+weizxm+"'," +
"'"+weizdz+"'," +
"'"+jiasy+"'," +
"'"+weizsj+"'," +
"'"+fakje+"'," +
"'"+bei+"'," +
"'"+date+"')" ;
System.out.println(sql);
dao.commOper(sql);
go("/admin/wzjl.jsp", request, response);
}
if(ac.equals("upwzjl"))
{
String id = request.getParameter("id");
String cheph = request.getParameter("cheph");
String weizxm = request.getParameter("weizxm");
String weizdz = request.getParameter("weizdz");
String jiasy = request.getParameter("jiasy");
String weizsj = request.getParameter("weizsj");
String fakje = request.getParameter("fakje");
String bei = request.getParameter("bei");
String sql="update wzinfo set cheph= '"+cheph+"'," +
"weizxm='"+weizxm+"'," +
"weizdz='"+weizdz+"'," +
"jiasy='"+jiasy+"'," +
"weizsj='"+weizsj+"'," +
"fakje='"+fakje+"'," +
"bei='"+bei+"' where id='"+id+"'" ;
System.out.println(sql);
dao.commOper(sql);
go("/admin/wzjl.jsp", request, response);
}
if(ac.equals("addfyzc"))
{
String cheph = request.getParameter("cheph");
String zhiclx = request.getParameter("zhiclx");
String zhicsj = request.getParameter("zhicsj");
for (int j = 0; j < 10000; j++) {
i = j;
String gday = Info.getDay(DATE1, j);
if (gday.equals(DATE2)) {
break;
}
}
return i;
}
/**
* 比较时间大小
*/
public static String compare_datezq(String DATE1, String DATE2) {
DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
try {
Date dt1 = df.parse(DATE1);
Date dt2 = df.parse(DATE2);
if (dt1.getTime() > dt2.getTime()) {
return "big";
} else if (dt1.getTime() < dt2.getTime()) {
return "small";
} else {
return "den";
}
} catch (Exception exception) {
exception.printStackTrace();
}
return "den";
}
/**
* 过滤html代码
*/
public static String filterStrIgnoreCase(String source, String from, String to) {
String sourceLowcase = source.toLowerCase();
String sub1, sub2, subLowcase1, subLowcase2;
sub1 = sub2 = subLowcase1 = subLowcase2 = "";
int start = 0, end;
boolean done = true;
if (source == null) return null;
}
if(ac.equals("uplsjl"))
{
String id = request.getParameter("id");
String cheph = request.getParameter("cheph");
String liansdj = request.getParameter("liansdj");
String lianssj = request.getParameter("lianssj");
String liansje = request.getParameter("liansje");
String xiaclssj = request.getParameter("xiaclssj");
String bei = request.getParameter("bei");
String sql="update lsinfo set cheph='"+cheph+"',liansdj='"+liansdj+"',lianssj='"+lianssj+"',liansje='"+liansje+"',xiaclssj='"+xiaclssj+"',bei='"+bei+"' where id="+id ;
System.out.println(sql);
dao.commOper(sql);
go("/admin/lsjl.jsp", request, response);
}
if(ac.equals("addsgjl"))
{
String cheph = request.getParameter("cheph");
String shiglx = request.getParameter("shiglx");
String jiasy = request.getParameter("jiasy");
String shigsj = request.getParameter("shigsj");
String fasdz = request.getParameter("fasdz");
String duifjsy = request.getParameter("duifjsy");
String duifcph = request.getParameter("duifcph");
String duiflxfs = request.getParameter("duiflxfs");
String gongscdje = request.getParameter("gongscdje");
String gercdje = request.getParameter("gercdje");
String duifcdje = request.getParameter("duifcdje");
String baoxcdje = request.getParameter("baoxcdje");
String bei = request.getParameter("bei");
String sql="insert into sginfo values( '"+cheph+"'," +
"'"+shiglx+"'," +
"'"+jiasy+"'," +
"'"+shigsj+"'," +
"'"+fasdz+"'," +
"'"+duifjsy+"'," +
"'"+duifcph+"'," +
"'"+duiflxfs+"'," +
"'"+gongscdje+"'," +
"'"+gercdje+"'," +
"'"+duifcdje+"'," +
"'"+baoxcdje+"'," +
"'"+bei+"'," +
}
if(ac.equals("uphs"))
{
String id =request.getParameter("id");
String cheph =request.getParameter("cheph");
String haoslx =request.getParameter("haoslx");
String biaoyr =request.getParameter("biaoyr");
String jiasy =request.getParameter("jiasy");
String biaoysj =request.getParameter("biaoysj");
String shiyou =request.getParameter("shiyou");
String bei =request.getParameter("bei");
String sql = "update hsinfo set cheph='"+cheph+"',haoslxc='"+haoslx+"',biaoyr='"+biaoyr+"',jiasy='"+jiasy+"',biaoysj='"+biaoysj+"',shiyou='"+shiyou+"',bei='"+bei+"' where id="+id;
dao.commOper(sql);
go("/admin/hsjl.jsp", request, response);
}
if(ac.equals("addts"))
{
String cheph =request.getParameter("cheph");
String haoslx =request.getParameter("haoslx");
String biaoyr =request.getParameter("biaoyr");
String jiasy =request.getParameter("jiasy");
String biaoysj =request.getParameter("biaoysj");
String shiyou =request.getParameter("shiyou");
String bei =request.getParameter("bei");
String sql = "insert into hsinfo values('"+cheph+"','"+haoslx+"','"+biaoyr+"','"+jiasy+"','"+biaoysj+"','"+shiyou+"','"+bei+"','"+Info.getDateStr()+"','2')";
dao.commOper(sql);
go("/admin/tsjl.jsp", request, response);
}
if(ac.equals("upts"))
{
String id =request.getParameter("id");
String cheph =request.getParameter("cheph");
String haoslx =request.getParameter("haoslx");
String biaoyr =request.getParameter("biaoyr");
String jiasy =request.getParameter("jiasy");
String biaoysj =request.getParameter("biaoysj");
String shiyou =request.getParameter("shiyou");
String jscode = "<TEXTAREA name=\"content\" id=\"content\">" + content + "</TEXTAREA>";
jscode += "<script language=\"javascript\">";
jscode += "function fckinit()";
jscode += "{";
jscode += " var of = new FCKeditor(\"content\");";
jscode += "of.BasePath=\"/foodemarket/fckeditor/\";";
jscode += "of.Height = \"" + height + "\";";
jscode += "of.ToolbarSet=\"Default\";";
jscode += "of.ReplaceTextarea();";
jscode += "}";
jscode += "fckinit();";
jscode += "</script>";
return jscode;
}
public synchronized static String subStr(String source, int length) {
if (source.length() > length) {
source = source.substring(0, length) + "...";
}
return source;
}
public static String getDateStr() {
String dateString = "";
try {//yyyyMMddHHmmss
java.text.SimpleDateFormat formatter = new java.text.SimpleDateFormat("yyyy-MM-dd hh:mm:ss");
java.util.Date currentTime_1 = new java.util.Date();
dateString = formatter.format(currentTime_1);
} catch (Exception e) {
}
return dateString;
}
public static String getUTFStr(String str) {
if (str == null) {
return "";
}
try {
str = new String(str.getBytes("ISO-8859-1"), "utf-8");
} catch (UnsupportedEncodingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return str;
}
request.getRequestDispatcher(url).forward(request, response);
} catch (ServletException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
public void gor(String url,HttpServletRequest request, HttpServletResponse response)
{
try {
response.sendRedirect(url);
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out = response.getWriter();
String ac = request.getParameter("ac");
if(ac==null)ac="";
CommDAO dao = new CommDAO();
String date = Info.getDateStr();
String today = date.substring(0,10);
String tomonth = date.substring(0,7);
//登录
if(ac.equals("login"))
{
String username = request.getParameter("uname");
String password = request.getParameter("upass");
String utype = request.getParameter("utype");
String sql = "select * from sysuser where uname='"+username+"' and upass='"+password+"' and utype='"+utype+"'";
List<HashMap> userlist = dao.select(sql);
if(userlist.size()!=1)
{
request.setAttribute("error", "");
go("/index.jsp", request, response);
}else{
String sql = "select * from sysuser where uname='"+username+"' and upass='"+password+"' and utype='"+utype+"'";
List<HashMap> userlist = dao.select(sql);
if(userlist.size()!=1)
{
request.setAttribute("error", "");
go("/index.jsp", request, response);
}else{
request.getSession(). setAttribute("user", userlist.get(0));
gor("/foodemarket/admin/index.jsp", request, response);
}
}
if(ac.equals("uploaddoc"))
{
try {
String filename="";
request.setCharacterEncoding("utf-8");
RequestContext requestContext = new ServletRequestContext(request);
if(FileUpload.isMultipartContent(requestContext)){
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setRepository(new File(request.getRealPath("/upfile/")+"/"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax(100*1024*1024);
List items = new ArrayList();
items = upload.parseRequest(request);
FileItem fileItem = (FileItem) items.get(0);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
filename = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + filename);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
}
go("/js/uploaddoc.jsp?docname="+filename, request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
//从内存中写入文件中
wwb.write();
//关闭资源,释放内存
wwb.close();
} catch (IOException e) {
e.printStackTrace();
} catch (Exception e) {
e.printStackTrace();
}
}
try {
response.sendRedirect("/foodemarket/upload?filename=" + fileName.substring(fileName.lastIndexOf("/") + 1));
} catch (IOException e) {
e.printStackTrace();
}
}
public static String getcheckbox(String name, String tablename, String zdname) {
String checkbox = "";
for (HashMap permap : new CommDAO().select("select * from " + tablename + " order by id desc")) {
checkbox += "<label><input type='checkbox' name='" + name + "' value=\"" + permap.get(zdname) + "\" />" + permap.get(zdname) + "</label>\n";
}
return checkbox;
}
public static String getFileUpInfo() {
String jscode = "";
jscode += "<font οnclick=\"uploaddoc()\" src=\"/foodemarket/js/nopic.jpg\" style='cursor:hand' id=txt >点击此处上传</font>";
jscode += " <input type=text readonly style='border:0px' size=30 name=\"docname\" id=\"docname\" value=\"\" />";
return jscode;
}
public static String tform(HashMap map) {
String jscode = "";
try {
jscode += "<script type=\"text/javascript\">\n";
{
String cheph = request.getParameter("cheph");
String weixjs = request.getParameter("weixjs");
String weixsj = request.getParameter("weixsj");
String weixgs = request.getParameter("weixgs");
String weixjl = request.getParameter("weixjl");
String weixc = request.getParameter("weixc");
String weixje = request.getParameter("weixje");
String jiasy = request.getParameter("jiasy");
String bei = request.getParameter("bei");
String guak = request.getParameter("guak");
String beiz = request.getParameter("beiz");
String sql="insert into wxinfo values('"+cheph+"','"+weixjs+"','"+weixsj+"','"+weixgs+"','"+weixjl+"','"+weixc+"','"+weixje+"','"+jiasy+"','"+bei+"','"+guak+"','"+beiz+"')" ;
dao.commOper(sql);
go("/admin/wxjl.jsp", request, response);
}
if(ac.equals("upwxjl"))
{
String id = request.getParameter("id");
String cheph = request.getParameter("cheph");
String weixjs = request.getParameter("weixjs");
String weixsj = request.getParameter("weixsj");
String weixgs = request.getParameter("weixgs");
String weixjl = request.getParameter("weixjl");
String weixc = request.getParameter("weixc");
String weixje = request.getParameter("weixje");
String jiasy = request.getParameter("jiasy");
String bei = request.getParameter("bei");
String guak = request.getParameter("guak");
String beiz = request.getParameter("beiz");
String sql="update wxinfo set cheph='"+cheph+"',weixjs='"+weixjs+"',weixsj='"+weixsj+"',weixgs='"+weixgs+"',weixjl='"+weixjl+"',weixc='"+weixc+"',weixje='"+weixje+"',jiasy='"+jiasy+"',bei='"+bei+"',guak='"+guak+"',beiz='"+beiz+"' where id="+id ;
dao.commOper(sql);
go("/admin/wxjl.jsp", request, response);
}
if(ac.equals("addtbjl"))
{
String cheph = request.getParameter("cheph");
String baoxlx = request.getParameter("baoxlx");
String baoxgs = request.getParameter("baoxgs");
String baodh = request.getParameter("baodh");
String taobsj = request.getParameter("taobsj");
String baoxje = request.getParameter("baoxje");
public static String getUTFStr(String str) {
if (str == null) {
return "";
}
try {
str = new String(str.getBytes("ISO-8859-1"), "utf-8");
} catch (UnsupportedEncodingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return str;
}
public static String getGBKStr(String str) throws UnsupportedEncodingException {
if (str == null) {
return "";
}
return new String(str.getBytes("ISO-8859-1"), "GBK");
}
public static String getGB2312Str(String str) throws UnsupportedEncodingException {
if (str == null) {
return "";
}
return new String(str.getBytes("ISO-8859-1"), "gb2312");
}
/**
*
* @param String date
* @param int day
* @return
*/
public static String getDay(String date, int day) {
String b = date.substring(0, 10);
String c = b.substring(0, 4);
/**
*
* @param 下一页的分页链接
* @param 一页最大记录数
* @param 当前HttpServletRequest对象
* @param 数据库操作对象
*/
public static PageManager getPage(String path, int pageSize,
HttpServletRequest request) {
return new PageManager(path, pageSize, request);
}
/**
*
*
* @param hql语句
*
*/
public void doList(String hql) {
this.count = this.dao.select(hql).size();
if (this.count != 0) {
this.pageNumber = count % this.pageSize == 0 ? this.count
/ this.pageSize : this.count / this.pageSize + 1;
if (this.currentPage > this.pageNumber)
this.currentPage = (int) this.pageNumber;
}
this.request.getSession().setAttribute("currentPage",
String.valueOf(this.currentPage));
this.collection = this.dao.select(hql,
this.currentPage , this.pageSize);
this.refreshUrl();
}
/**
*
* @param 查询条件集合
* 如没有条件只是列表就不使用这个方法
*/
public void addParameter(List parameter) {
StringBuffer para = new StringBuffer("");
if (parameter != null && parameter.size() != 0) {
Iterator iterator = parameter.iterator();
}
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return i;
}
public void commOper(String sql) {
try {
Statement st = conn.createStatement();
st.execute(sql);
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public void commOperSqls(ArrayList<String> sql) {
try {
conn.setAutoCommit(false);
for (int i = 0; i < sql.size(); i++) {
Statement st = conn.createStatement();
System.out.println(sql.get(i));
st.execute(sql.get(i));
st.close();
}
conn.commit();
} catch (SQLException e) {
try {
conn.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
e.printStackTrace();
} finally {
try {
conn.setAutoCommit(true);
} catch (SQLException e) {
e.printStackTrace();
}
if(ac.equals("updatejsy"))
{
String id = request.getParameter("id");
String xinmin=request.getParameter("xinmin");
String gonghao=request.getParameter("gonghao");
String filename=request.getParameter("filename");
String xinbie=request.getParameter("xinbie");
String xueli=request.getParameter("xueli");
String senri=request.getParameter("senri");
String jiguan=request.getParameter("jiguan");
String dianhua=request.getParameter("dianhua");
String souji=request.getParameter("souji");
String sql = "update yudiinfo set xinmin='"+xinmin+"',gonghao='"+gonghao+"',filename='"+filename+"',xinbie='"+xinbie+"',xueli='"+xueli+"',senri='"+senri+"',jiguan='"+jiguan+"',dianhua='"+dianhua+"',souji='"+souji+"' where id="+id;
dao.commOper(sql);
request.setAttribute("suc", "");
request.setAttribute("suc", "");
go("/admin/jsydj.jsp", request, response);
}
if(ac.equals("addcl"))
{
String cheph = request.getParameter("cheph");
String pinpai = request.getParameter("pinpai");
String xinhao = request.getParameter("xinhao");
String filename = request.getParameter("filename");
String fadjh = request.getParameter("fadjh");
String dipanhao = request.getParameter("dipanhao");
String yanse = request.getParameter("yanse");
String jijiaoqih = request.getParameter("jijiaoqih");
String goumaije = request.getParameter("goumaije");
String sencangrq = request.getParameter("sencangrq");
String goumairq = request.getParameter("goumairq");
String sql= "insert into stuinfo values('"+cheph+"','"+pinpai+"','"+xinhao+"','"+filename+"','"+fadjh+"','"+dipanhao+"','"+yanse+"','"+jijiaoqih+"','"+goumaije+"','"+sencangrq+"','"+goumairq+"','"+date+"')";
dao.commOper(sql);
request.setAttribute("suc", "");
go("/admin/cldj.jsp", request, response);
}
if(ac.equals("upcl"))
{
String id = request.getParameter("id");
String cheph = request.getParameter("cheph");
String pinpai = request.getParameter("pinpai");
String xinhao = request.getParameter("xinhao");
String filename = request.getParameter("filename");
String fadjh = request.getParameter("fadjh");