Struts2 实例 (登陆+增删改查+数据库文件+配置文件)

package org.xx.service; import java.sql.*; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.List; import org.xx.model.People; import org.xx.model.users; import org.xx.util.DB; import java.sql.Date; public class HandleService { private Connection conn = null; private PreparedStatement sts = null; ResultSet res = null; /** * 查找列表 * * @return */ public List<People> check() { conn = DB.createConn(); List<People> lists = null; String sql = "select * from People"; try { sts = conn.prepareStatement(sql); lists = new ArrayList<People>(); res = sts.executeQuery(); People p = null; while (res.next()) { p = new People(); p.setId(res.getInt("id")); p.setAddress(res.getString("address")); p.setName(res.getString("name")); p.setPassword(res.getString("password")); p.setDate(res.getDate("date")); lists.add(p); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } DB.close(res); DB.close(sts); DB.close(conn); return lists; } /** * 根据ID删除对象 * * @param id */ public void deletebydi(int id) { conn = DB.createConn(); String sql = "delete from People where id=?"; try { sts = conn.prepareStatement(sql); sts.setInt(1, id); sts.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } DB.close(sts); DB.close(conn); } /** * 删除对象 * * @param p */ public void delete(People p) { deletebydi(p.getId()); } /** * 更新 * * @param p */ public void update(People p) { conn = DB.createConn(); SimpleDateFormat sdFormat = new SimpleDateFormat("yy-MM-dd hh:mm:ss"); try { String sql = "update People set name=?,address=?,password=?,date=? where id=?"; sts = conn.prepareStatement(sql); sts.setString(1, p.getName()); sts.setString(2, p.getAddress()); sts.setString(3, p.getPassword()); sts.setString(4, sdFormat.format(p.getDate())); sts.setInt(5, p.getId()); sts.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } DB.close(sts); DB.close(conn); } /** * 添加 * * @param p */ public int add(People p) { int a = 0; conn = DB.createConn(); SimpleDateFormat sdFormat = new SimpleDateFormat("yy-MM-dd hh:mm:ss"); String sql = "insert into People values(?,?,?,?)"; try { sts = conn.prepareStatement(sql); sts.setString(1, p.getName()); sts.setString(2, p.getAddress()); sts.setString(3, p.getPassword()); sts.setString(4, sdFormat.format(p.getDate())); sts.executeUpdate(); a = 1; } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } DB.close(sts); DB.close(conn); return a; } /** * 根据ID查找 * * @param id */ public People findbyId(int id) { conn = DB.createConn(); String sql = "select * from People where id=?"; People p = null; try { sts = conn.prepareStatement(sql); sts.setInt(1, id); res = sts.executeQuery(); if (res.next()) { p = new People(); p.setId(res.getInt("id")); p.setName(res.getString("name")); p.setAddress(res.getString("address")); p.setPassword(res.getString("password")); p.setDate(res.getDate("date")); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } DB.close(sts); DB.close(conn); return p; } /** * 查找用户 */ public List<users> checks(users s) { conn = DB.createConn(); String sql = "select * from users where name=? and password=?"; List<users> userss = null; try { new ArrayList<users>(); sts = conn.prepareStatement(sql); sts.setString(1,s.getName()); sts.setString(2,s.getPassword()); res = sts.executeQuery(); users users1 = null; userss=new ArrayList<users>(); while(res.next()) { users1 = new users(); users1.setName(res.getString("name")); users1.setPassword(res.getString("password")); userss.add(users1); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); System.out.println("错误"); } DB.close(res); DB.close(sts); DB.close(conn); System.out.print("ccc"); return userss; } }