基于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 登录
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();
filename = ((FileItem) items.get(0)).getString();
filename = Info.getUTFStr(filename);
filebei = ((FileItem) items.get(2)).getString();
filebei = Info.getUTFStr(filebei);
FileItem fileItem = (FileItem) items.get(1);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
fileurl = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + fileurl);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
}
String sql = "insert into kcfiles values('"+filename+"','"+fileurl+"','"+filebei+"')";
dao.commOper(sql);
go("/admin/kcfiles.jsp", request, response);
} catch (Exception e1) {
e1.printStackTrace();
}
}
if(ac.equals("uploadimg"))
{
try {
String filename="";
request.setCharacterEncoding("utf-8");
}
}
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();
}
}
}
public List<HashMap> select(String sql) {
List<HashMap> list = new ArrayList();
try {
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
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"))
radio += "<label><input type='radio' name='" + name + "' value=\"" + permap.get(zdname) + "\" />" + permap.get(zdname) + "</label>\n";
}
return radio;
}
public static void writeExcel(String fileName, String prosstr, java.util.List<List> list, HttpServletRequest request, HttpServletResponse response) {
WritableWorkbook wwb = null;
String cols = "";
for (String str : prosstr.split("@")) {
cols += str.split("-")[0] + ",";
}
cols = cols.substring(0, cols.length() - 1);
list = new CommDAO().selectforlist("select " + cols + " from " + fileName + " order by id desc");
fileName = request.getRealPath("/") + "/upfile/a.xls";
String[] pros = prosstr.split("@");
try {
//首先要使用Workbook类的工厂方法创建一个可写入的工作薄(Workbook)对象
wwb = Workbook.createWorkbook(new File(fileName));
} catch (IOException e) {
e.printStackTrace();
}
if (wwb != null) {
//创建一个可写入的工作表
//Workbook的createSheet方法有两个参数，第一个是工作表的名称，第二个是工作表在工作薄中的位置
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();
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();
while (iterator.hasNext()) {
para.append("&").append(iterator.next().toString());
}
}
this.parameter = para.toString();
}
/**
* 刷新分页路径
*
*/
protected void refreshUrl() {
StringBuffer buf = new StringBuffer();
buf.append("<font color='#1157B7'>共").append(count);
buf.append("条");
buf.append(" ");
buf.append("第").append(this.currentPage).append("/").append(
this.pageNumber).append("页");
buf.append(" ");
if (this.currentPage == 1)
buf.append("首页");
request.setAttribute("page", this);
try {
this.currentPage = Integer.parseInt(request
.getParameter("currentPage")) <= 0 ? 1 : Integer
.parseInt(request.getParameter("currentPage"));
} catch (Exception e) {
try {
this.currentPage = Integer.parseInt((String) request
.getSession().getAttribute("currentPage"));
} catch (Exception e1) {
this.currentPage = 1;
}
}
}
/**
*
* @param 下一页的分页链接
* @param 一页最大记录数
* @param 当前HttpServletRequest对象
* @param 数据库操作对象
*/
public static PageManager getPage(String path, int pageSize,
HttpServletRequest request) {
return new PageManager(path, pageSize, request);
}
String cheph = request.getParameter("cheph");
String zhiclx = request.getParameter("zhiclx");
String zhicsj = request.getParameter("zhicsj");
String zhicje = request.getParameter("zhicje");
String jiasy = request.getParameter("jiasy");
String bei = request.getParameter("bei");
String sql="update fyzcinfo set cheph= '"+cheph+"'," +
"zhiclx='"+zhiclx+"'," +
"zhicsj='"+zhicsj+"'," +
"zhicje='"+zhicje+"'," +
"jiasy='"+jiasy+"'," +
"bei='"+bei+"' where id='"+id+"'" ;
System.out.println(sql);
dao.commOper(sql);
go("/admin/fyzc.jsp", request, response);
}
if(ac.equals("addqtsr"))
{
String cheph = request.getParameter("cheph");
String shourlx = request.getParameter("shourlx");
String shoursj = request.getParameter("shoursj");
String shourje = request.getParameter("shourje");
String jiasy = request.getParameter("jiasy");
String bei = request.getParameter("bei");
String sql="insert into qtsrinfo values( '"+cheph+"'," +
"'"+shourlx+"'," +
"'"+shoursj+"'," +
"'"+shourje+"'," +
"'"+jiasy+"'," +
"'"+bei+"'," +
"'"+date+"')" ;
System.out.println(sql);
dao.commOper(sql);
go("/admin/qtsr.jsp", request, response);
}
if(ac.equals("upqtsr"))
{
for (HashMap permap : new CommDAO().select("select * from " + tablename + " order by id desc")) {
radio += "<label><input type='radio' name='" + name + "' value=\"" + permap.get(zdname) + "\" />" + permap.get(zdname) + "</label>\n";
}
return radio;
}
public static void writeExcel(String fileName, String prosstr, java.util.List<List> list, HttpServletRequest request, HttpServletResponse response) {
WritableWorkbook wwb = null;
String cols = "";
for (String str : prosstr.split("@")) {
cols += str.split("-")[0] + ",";
}
cols = cols.substring(0, cols.length() - 1);
list = new CommDAO().selectforlist("select " + cols + " from " + fileName + " order by id desc");
fileName = request.getRealPath("/") + "/upfile/a.xls";
String[] pros = prosstr.split("@");
try {
//首先要使用Workbook类的工厂方法创建一个可写入的工作薄(Workbook)对象
wwb = Workbook.createWorkbook(new File(fileName));
} catch (IOException e) {
e.printStackTrace();
}
if (wwb != null) {
//创建一个可写入的工作表
//Workbook的createSheet方法有两个参数，第一个是工作表的名称，第二个是工作表在工作薄中的位置
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, "");
e1.printStackTrace();
}
}
if(ac.equals("addkcfiles"))
{
try {
String filename = "";
String fileurl="";
String filebei = "";
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();
filename = ((FileItem) items.get(0)).getString();
filename = Info.getUTFStr(filename);
filebei = ((FileItem) items.get(2)).getString();
filebei = Info.getUTFStr(filebei);
FileItem fileItem = (FileItem) items.get(1);
if(fileItem.getName()!=null && fileItem.getSize()!=0)
{
if(fileItem.getName()!=null && fileItem.getSize()!=0){
File fullFile = new File(fileItem.getName());
fileurl = Info.generalFileName(fullFile.getName());
File newFile = new File(request.getRealPath("/upfile/")+"/" + fileurl);
try {
fileItem.write(newFile);
} catch (Exception e) {
e.printStackTrace();
}
}else{
}
}
}
String sql = "insert into kcfiles values('"+filename+"','"+fileurl+"','"+filebei+"')";
dao.commOper(sql);
go("/admin/kcfiles.jsp", request, response);
} catch (Exception e1) {
e1.printStackTrace();
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();
}
}
//登录
if(ac.equals("flogin"))
{
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+"' ";
List<HashMap> userlist = dao.select(sql);
if(userlist.size()!=1)
{
request.setAttribute("error", "");
go("/login.jsp", request, response);
}else{
request.getSession(). setAttribute("user", userlist.get(0));
gor("index.jsp", request, response);
}
}
//修改密码
if(ac.equals("uppass"))
{
if (j == i) {
thePics1.append(url.replaceAll("\n", ""));
theLinks1.append("xiang.jsp?id=" + b.get("id"));
theTexts1.append(title);
}
}
thePics1.append("';");
theLinks1.append("';");
theTexts1.append("';");
imgStr.append(thePics1 + "\n");
imgStr.append(theLinks1 + "\n");
imgStr.append(theTexts1 + "\n");
imgStr.append("\n setPic(thePics1,theLinks1,theTexts1," + width + "," + height + ",'picViwer1');</script>");
return imgStr.toString();
}
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,
// 默认一页最大记录数
public static final int DEFAULTPAGESIZE = 20;
// 分页段
public static final int segment = 10;
// 当前页数
protected int currentPage;
// 一页长度
protected int pageSize;
// 总页数
protected long pageNumber;
// 总记录数
protected long count;
// 数据
protected Collection collection;
// 数据查询对象
protected CommDAO dao = new CommDAO();
// 表现层代码
protected String info;
// 请求路径
protected String path;
// 服务器请求对象
protected HttpServletRequest request;
/*
* 仅仅只是加到路径中去
*/
protected String parameter = "";
/**
*
String a = "";
DateFormat dateFormat = DateFormat.getDateInstance(DateFormat.MEDIUM);
GregorianCalendar grc = new GregorianCalendar();
grc.setTime(new Date(aa));
grc.add(GregorianCalendar.DAY_OF_MONTH, day);
String resu = dateFormat.format(grc.getTime());
String t[] = resu.split("-");
String sesuu = "";
for (int i = 0; i < t.length; i++) {
if (t[i].length() == 1) {
t[i] = "0" + t[i];
}
sesuu += t[i] + "-";
}
return sesuu.substring(0, 10);
}
/**
* 计算两个时期之间的天数
*/
public static int dayToday(String DATE1, String DATE2) {
int i = 0;
if (DATE1.indexOf(" ") > -1)
DATE1 = DATE1.substring(0, DATE1.indexOf(" "));
if (DATE2.indexOf(" ") > -1)
DATE2 = DATE2.substring(0, DATE2.indexOf(" "));
String[] d1 = DATE1.split("-");
if (d1[1].length() == 1) {
DATE1 = d1[0] + "-0" + d1[1];
} else {
DATE1 = d1[0] + "-" + d1[1];
}
if (d1[2].length() == 1) {
DATE1 = DATE1 + "-0" + d1[2];
} else {
DATE1 = DATE1 + "-" + d1[2];
}
String[] d2 = DATE2.split("-");
if (d2[1].length() == 1) {
DATE2 = d2[0] + "-0" + d2[1];
} else {
DATE2 = d2[0] + "-" + d2[1];
}
HashMap typemap = new HashMap();
ArrayList<String> collist = new ArrayList();
String sql = "update " + tablename + " set ";
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++) {
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)) + "',";
}
}
}
}
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";
jscode += "function getPvalue()\n";
jscode += "{\n";
Set set = map.entrySet();
Iterator it = set.iterator();
while (it.hasNext()) {
String pm = ((Object) it.next()).toString();
String str1 = "";
String str2 = "";
String[] strs = pm.split("=");
str1 = strs[0];
if (strs.length == 1) str2 = "";
if (strs.length == 2) str2 = strs[1];
str2 = str2.replaceAll("\r\n", "-----");
if (!str1.equals("content")) {
jscode += " if(document.getElementsByName(\"" + str1 + "\").length>1)\n";
jscode += " {\n";
jscode += " var radios = document.getElementsByName(\"" + str1 + "\");\n";
jscode += " if(radios[0].type=='radio'){\n";
jscode += " for(var i=0;i<radios.length;i++)\n";
jscode += " {\n";
jscode += " if(radios[i].value==\"" + str2 + "\")\n";
jscode += " {\n";
jscode += " radios[i].checked=\"checked\";\n";
jscode += " }\n";
jscode += " }\n";
jscode += " }\n";
jscode += " if(radios[0].type=='checkbox'){\n";
jscode += " for(var i=0;i<radios.length;i++)\n";
jscode += " {\n";
jscode += " if(\"" + str2 + "\".indexOf(radios[i].value)>-1)\n";
jscode += " {\n";
jscode += " radios[i].checked=\"checked\";\n";
this.parameter = para.toString();
}
/**
* 刷新分页路径
*
*/
protected void refreshUrl() {
StringBuffer buf = new StringBuffer();
buf.append("<font color='#1157B7'>共").append(count);
buf.append("条");
buf.append(" ");
buf.append("第").append(this.currentPage).append("/").append(
this.pageNumber).append("页");
buf.append(" ");
if (this.currentPage == 1)
buf.append("首页");
else
buf.append("<a href='").append(this.path).append("¤tPage=1")
.append(parameter)
.append("' class='ls'>").append("首页")
.append("</a>");
// #1157B7
buf.append(" ");
if (this.currentPage > 1) {
buf.append("<a href='").append(this.path).append("¤tPage=")
.append(currentPage - 1).append(parameter).append(
"' class='ls'>").append("上页")
.append("</a>");
} else {
buf.append("上页");
}
buf.append(" ");
int currentSegment = this.currentPage % segment == 0 ? this.currentPage
/ segment : this.currentPage / segment + 1;
/*for (int i = 1; i <= this.pageNumber; i++) {
if (this.currentPage == i)
buf.append("<font color='red'>").append(i).append("</font>");
else
if(ac.equals("upyj"))
{
String yinjsj = request.getParameter("yinjsj");
String shijsj = request.getParameter("shijsj");
String bei = request.getParameter("bei");
String guanlf = request.getParameter("guanlf");
String shuis = request.getParameter("shuis");
String gpsf = request.getParameter("gpsf");
String ffbz = request.getParameter("ffbz");
String yinjhj = request.getParameter("yinjhj");
String shijje = request.getParameter("shijje");
String chae = request.getParameter("chae");
String id = request.getParameter("id");
String sql = "update yjkdj set yinjsj='"+yinjsj+"', shijsj='"+shijsj+"', bei='"+bei+"', guanlf='"+guanlf+"', shuis='"+shuis+"', gpsf='"+gpsf+"', ffbz='"+ffbz+"', yinjhj='"+yinjhj+"', shijje='"+shijje+"', chae='"+chae+"' where id="+id;
dao.commOper(sql);
String type = request.getParameter("type");
if(type==null)type="";
if(type.equals(""))type="/admin/scldd.jsp";
if(type.equals("jk"))type="/admin/sjkdj.jsp";
go(type, request, response);
}
if(ac.equals("addwxjl"))
{
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");
DATE2 = DATE2 + "-0" + d2[2];
} else {
DATE2 = DATE2 + "-" + d2[2];
}
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";
}
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
String str = "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">"
+ "<script language=javascript>\n";
if (alert) {
str += "alert('操作成功');\n";
}
if (reflush) {
str += "parent.location=parent.location;\n";
}
str += "</script>\n";
PrintWriter wrt = null;
try {
// request.get
wrt = response.getWriter();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
wrt.write(str);
}
return "";
}
public int getInt(String sql) {
int i = 0;
try {
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(sql);
if (rs.next()) {
i = rs.getInt(1);
}
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return i;
}
public double getDouble(String sql) {
double i = 0;
try {
Statement st = conn.createStatement();
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
