81,122
社区成员




package oper;
import java.sql.*;
import java.util.ArrayList;
import voo.Userinfo;
import conn.DbConn;
public class UserInfoOper {
//查询单个用户的方法
public Userinfo selectOne(int userid){
Connection conn = null;
try {
conn = DbConn.getConn();
String sql = "select * from userinfo where userid=?";
PreparedStatement pstmt =
conn.prepareStatement(sql);
pstmt.setInt(1,userid);
ResultSet rs = pstmt.executeQuery();
rs.next();
Userinfo ui = new Userinfo();
ui.setUserid(rs.getInt(1));
ui.setUname(rs.getString(2));
ui.setUpass(rs.getString(3));
ui.setUsersex(rs.getString(4));
ui.setUserage(rs.getInt(5));
ui.setUseradd(rs.getString(6));
return ui;
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
return null;
} finally{
if(conn!=null)
try {
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
//查询方法
public ArrayList selectAll(){
Connection conn = null;
try {
conn = DbConn.getConn();
String sql = "select * from userinfo";
PreparedStatement pstmt =
conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
ArrayList al = new ArrayList();
while(rs.next()){
Userinfo ui = new Userinfo();
ui.setUserid(rs.getInt(1));
ui.setUname(rs.getString(2));
ui.setUpass(rs.getString(3));
ui.setUsersex(rs.getString(4));
ui.setUserage(rs.getInt(5));
ui.setUseradd(rs.getString(6));
ui.setPhotopath(rs.getString(8));
al.add(ui);
}
return al;
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
return null;
} finally{
if(conn!=null)
try {
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
//增加方法
public void insert(Userinfo ui){
Connection conn = null;
try {
conn = DbConn.getConn();
String sql = "insert into userinfo(username,userpass,usersex,userage,useradd,photopath) values (?,?,?,?,?,?)";
PreparedStatement pstmt =
conn.prepareStatement(sql);
pstmt.setString(1,ui.getUname());
pstmt.setString(2,ui.getUpass());
pstmt.setString(3,ui.getUsersex());
pstmt.setInt(4,ui.getUserage());
pstmt.setString(5,ui.getUseradd());
pstmt.setString(6,ui.getPhotopath());
pstmt.executeUpdate();
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} finally{
if(conn!=null)
try {
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
//删除
public void delete(int userid){
Connection conn = null;
try {
conn = DbConn.getConn();
String sql = "delete from userinfo where userid = ?";
PreparedStatement pstmt =
conn.prepareStatement(sql);
pstmt.setInt(1,userid);
pstmt.executeUpdate();
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} finally{
if(conn!=null)
try {
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
//修改
public void update(Userinfo ui){
Connection conn = null;
try {
conn = DbConn.getConn();
String sql = "UPDATE USERINFO set username=?,userpass=?,usersex=?,userage=?,useradd=? where userid=?";
PreparedStatement pstmt =
conn.prepareStatement(sql);
pstmt.setString(1,ui.getUname());
pstmt.setString(2,ui.getUpass());
pstmt.setString(3,ui.getUsersex());
pstmt.setInt(4,ui.getUserage());
pstmt.setString(5,ui.getUseradd());
pstmt.setInt(6,ui.getUserid());
pstmt.executeUpdate();
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
} finally{
if(conn!=null)
try {
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
//判断用户名和密码是否存在
public boolean check(Userinfo ui){
Connection conn = null;
try {
conn = DbConn.getConn();
String sql = "select count(*) from userinfo where username=? and userpass=?";
PreparedStatement pstmt =
conn.prepareStatement(sql);
pstmt.setString(1,ui.getUname());
pstmt.setString(2,ui.getUpass());
ResultSet rs = pstmt.executeQuery();
rs.next();
int n = rs.getInt(1);
if(n>0) return true;
else
return false;
} catch (Exception e) {
// TODO 自动生成 catch 块
e.printStackTrace();
return false;
} finally{
if(conn!=null)
try {
conn.close();
} catch (SQLException e) {
// TODO 自动生成 catch 块
e.printStackTrace();
}
}
}
}
package com.action;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.util.List;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.bean.T1Bean;
import com.bo.T1Bo;
public class Action extends HttpServlet {
private T1Bo bo;
/**
* The doGet method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to get.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// response.setContentType("text/html");
// PrintWriter out = response.getWriter();
// out
// .println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
// out.println("<HTML>");
// out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
// out.println(" <BODY>");
// out.print(" This is ");
// out.print(this.getClass());
// out.println(", using the GET method");
// out.println(" </BODY>");
// out.println("</HTML>");
// out.flush();
// out.close();
doPost(request, response);
}
/**
* The doPost method of the servlet. <br>
*
* This method is called when a form has its tag value method equals to post.
*
* @param request the request send by the client to the server
* @param response the response send by the server to the client
* @throws ServletException if an error occurred
* @throws IOException if an error occurred
*/
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
// response.setContentType("text/html");
// PrintWriter out = response.getWriter();
// out
// .println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");
// out.println("<HTML>");
// out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");
// out.println(" <BODY>");
// out.print(" This is ");
// out.print(this.getClass());
// out.println(", using the POST method");
// out.println(" </BODY>");
// out.println("</HTML>");
// out.flush();
// out.close();
bo = new T1Bo();
String method = request.getParameter("method");
if(method == null || method.equals("getData"))
{
try {
// ��BO�л�ȡ���
List<T1Bean> list = bo.getData();
// ����request��
request.setAttribute("data", list);
// ��ת��index.jsp
RequestDispatcher rd = request.getRequestDispatcher("index.jsp");
rd.forward(request, response);
} catch (ClassNotFoundException e) {
// TODO �Զ���� catch ��
e.printStackTrace();
} catch (SQLException e) {
// TODO �Զ���� catch ��
e.printStackTrace();
}
}
else if(method.equals("save"))
{
try {
T1Bean bean = new T1Bean();
bean.setT1_C1(request.getParameter("c1"));
bean.setT1_C2(request.getParameter("c2"));
bo.addData(bean);
response.sendRedirect("Action");
} catch (ClassNotFoundException e) {
// TODO �Զ���� catch ��
e.printStackTrace();
} catch (SQLException e) {
// TODO �Զ���� catch ��
e.printStackTrace();
}
}
else if(method.equals("remove"))
{
try {
T1Bean bean = new T1Bean();
bean.setT1_ID(Integer.parseInt(request.getParameter("id")));
bo.delData(bean);
response.sendRedirect("Action");
} catch (ClassNotFoundException e) {
// TODO �Զ���� catch ��
e.printStackTrace();
} catch (SQLException e) {
// TODO �Զ���� catch ��
e.printStackTrace();
}
}
}
}