package com;
import com.DBpool;
import java.io.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;
import javax.naming.NamingException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpSession;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class DBServlet extends HttpServlet
{
private Connection conn;
private Statement state;
private PreparedStatement pstate;
private ResultSet rs;
public DBServlet()
{
super();
}
public void init() throws ServletException
{
if(conn==null)
{
try
{
conn=DBpool.getConnection();
}
catch(NamingException e)
{
e.printStackTrace();
}
catch(SQLException se)
{
se.printStackTrace();
}
}
}
public void destroy()
{
super.destroy();
try
{
conn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
public Vector getTong()
{
Vector v=new Vector();
try
{
state=conn.createStatement();
rs=state.executeQuery("select * from tongxunlu");
while(rs.next())
{
TongBean tb=new TongBean(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8));
v.add(tb);
}
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
rs.close();
state.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
return v;
}
public TongBean getTongById(String id)
{
TongBean tb=new TongBean();
try
{
state=conn.createStatement();
rs=state.executeQuery("select * from tongxunlu where id="+id);
if(rs.next())
{
tb=new TongBean(rs.getInt(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8));
}
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
rs.close();
state.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
return tb;
}
public boolean addTong(TongBean tb)
{
int jg=0;
try
{
pstate=conn.prepareStatement("insert into tongxunlu (name,age,sex,address,phone,QQ,email) values (?,?,?,?,?,?,?)");
pstate.setString(1,tb.getName());
pstate.setString(2,tb.getAge());
pstate.setString(3,tb.getSex());
pstate.setString(4,tb.getAddress());
pstate.setString(5,tb.getPhone());
pstate.setString(6,tb.getQq());
pstate.setString(7,tb.getEmail());
jg=pstate.executeUpdate();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
pstate.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
if(jg>0)
return true;
else
return false;
}
public boolean updateTong(TongBean tb)
{
int jg=0;
try
{
pstate=conn.prepareStatement("update tongxunlu set name=?,age=?,sex=?,address=?,phone=?,QQ=?,email=? where id=?");
pstate.setString(1,tb.getName());
pstate.setString(2,tb.getAge());
pstate.setString(3,tb.getSex());
pstate.setString(4,tb.getAddress());
pstate.setString(5,tb.getPhone());
pstate.setString(6,tb.getQq());
pstate.setString(7,tb.getEmail());
pstate.setInt(8,tb.getId());
jg=pstate.executeUpdate();
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
pstate.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
if(jg>0)
return true;
return false;
}
public boolean delTong(String id)
{
int jg=0;
try
{
state=conn.createStatement();
jg=state.executeUpdate("delete from tongxunlu where id in ("+id+")");
}
catch(SQLException e)
{
e.printStackTrace();
}
finally
{
try
{
state.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
}
if(jg>0)
return true;
return false;
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
request.setCharacterEncoding("utf-8");
response.setContentType("text/html; charset=utf-8");
String type=request.getParameter("type");
HttpSession hs=request.getSession();
if(type==null||type.equals("null"))
{
hs.setAttribute("tongList", this.getTong());
response.sendRedirect("index.jsp");
}
else
{
if(type.equals("one"))
{
String id=request.getParameter("id");
hs.setAttribute("tongOne", this.getTongById(id));
response.sendRedirect("editTong.jsp");
}
if(type.equals("add"))
{
String name=request.getParameter("name");
String age=request.getParameter("age");
String sex=request.getParameter("sex");
String address=request.getParameter("address");
String phone=request.getParameter("phone");
String qq=request.getParameter("qq");
String email=request.getParameter("email");
TongBean tb=new TongBean(0,name,age,sex,address,phone,qq,email);
if(this.addTong(tb))
{
hs.setAttribute("tongList", this.getTong());
response.sendRedirect("index.jsp");
}
}
if(type.equals("update"))
{
String id=request.getParameter("id");
String name=request.getParameter("name");
String age=request.getParameter("age");
String sex=request.getParameter("sex");
String address=request.getParameter("address");
String phone=request.getParameter("phone");
String qq=request.getParameter("qq");
String email=request.getParameter("email");
TongBean tb=new TongBean(Integer.parseInt(id),name,age,sex,address,phone,qq,email);
if(this.updateTong(tb))
{
hs.setAttribute("tongList", this.getTong());
response.sendRedirect("index.jsp");
}
}
if(type.equals("del"))
{
String id=request.getParameter("id");
if(this.delTong(id))
{
hs.setAttribute("tongList", this.getTong());
response.sendRedirect("index.jsp");
}
}
}
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException
{
doPost(request,response);
}
}
没有合适的资源?快使用搜索试试~ 我知道了~
JSP+Ajax网站经典实例
共732个文件
jsp:211个
gif:97个
html:79个
需积分: 9 8 下载量 67 浏览量
2011-01-13
10:06:33
上传
评论
收藏 14.67MB RAR 举报
温馨提示
JSP+AJax网站经典实例 JSP经典实例 AJax经典实例 代码示例
资源推荐
资源详情
资源评论
收起资源包目录
JSP+Ajax网站经典实例 (732个子文件)
up.bmp 1KB
up.bmp 1KB
down.bmp 1KB
down.bmp 1KB
DBServlet.class 7KB
DBServlet.class 6KB
upload_Bean.class 5KB
DBServlet.class 5KB
ShoppingDAO.class 4KB
DBServlet.class 4KB
UserDAO.class 4KB
DatabaseDAO.class 3KB
LoginServlet.class 3KB
xiug.class 3KB
SearchSuggest.class 3KB
UserDAO.class 3KB
UserDAO.class 3KB
ProductDAO.class 3KB
richeng.class 3KB
ImgServlet.class 3KB
jh.class 3KB
jindt.class 3KB
UserDAO.class 3KB
jiax.class 2KB
renw.class 2KB
StuDAO.class 2KB
tx.class 2KB
login.class 2KB
YahooSearchGatewayServlet.class 2KB
tian.class 2KB
UserDAO.class 2KB
NumberGuessServlet.class 2KB
StuDAO.class 2KB
UserDAO.class 2KB
rizhi.class 2KB
TongBean.class 2KB
PostDAO.class 2KB
yijian.class 2KB
RequestSQL.class 2KB
SqlCheck.class 2KB
DateJM.class 2KB
Regist.class 2KB
Conn.class 2KB
CalendarOP.class 2KB
CounterBean.class 2KB
check.class 2KB
CheckName.class 2KB
CalculatorBean.class 2KB
shenp1.class 2KB
NumberGuessBean.class 1KB
FileBean.class 1KB
FileFilterBean.class 1KB
CalendarBean.class 1KB
ShoppingBean.class 1KB
ShoppingBean.class 1KB
DBpool.class 1006B
DBpool.class 1005B
DBpool.class 1004B
DBpool.class 1002B
DBpool.class 1002B
DBpool.class 1001B
DBpool.class 1001B
DBpool.class 1001B
DBpool.class 1001B
UserBean.class 831B
UserBean.class 831B
UserBean.class 831B
tree.css 453B
tree.css 453B
oa_jiaban.frm 9KB
renwu.frm 9KB
oa_qingjia.frm 9KB
oa_user.frm 9KB
oa_jihua.frm 9KB
oa_richeng.frm 9KB
oa_chucai.frm 9KB
user.frm 9KB
user.frm 9KB
oa_kaoqin.frm 9KB
oa_rizhi.frm 9KB
tongxunlu.frm 9KB
tongxunlu.frm 9KB
tongxunlu.frm 9KB
renwu_jind.frm 9KB
user.frm 9KB
user.frm 9KB
user.frm 9KB
query_step.frm 9KB
query_step.frm 9KB
query_step.frm 9KB
postcode.frm 8KB
postcode.frm 8KB
postcode.frm 8KB
renwu_yijian.frm 8KB
news.frm 8KB
news.frm 8KB
product.frm 8KB
product.frm 8KB
product.frm 8KB
sort.frm 8KB
共 732 条
- 1
- 2
- 3
- 4
- 5
- 6
- 8
资源评论
lgrong1011
- 粉丝: 0
- 资源: 5
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功