一个struts的样例

package com.inspur; import java.sql.Connection; import java.sql.Date; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; /** * @author 张英锋 * */ public class UserDAO { private static Connection conn=ConnectionFactory.getConnection(); /** * @param username * @param password * @return */ public static int addUser(UserForm u){ int number=0; try { PreparedStatement pstmt=conn.prepareStatement("insert into t_user values('',?,?,to_date(?,'yyyy-mm-dd'),?,?,?)"); pstmt.setString(1,u.getUsername()); pstmt.setString(2,u.getPassword()); pstmt.setString(3,u.getBirthday()); pstmt.setString(4,u.getGender()); pstmt.setString(5,u.getNation()); pstmt.setString(6,u.getUser_desc()); number = pstmt.executeUpdate(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return number; } /** * @param username * @param password * @return */ public static int updateUser(UserForm u){ int number=0; try { PreparedStatement pstmt=conn.prepareStatement("update t_user set username=?,password=?,birthday=to_date(?,'yyyy-mm-dd'),gender=?,nation=?,user_desc=? where id=?"); pstmt.setString(1,u.getUsername()); pstmt.setString(2,u.getPassword()); pstmt.setString(3,u.getBirthday()); pstmt.setString(4,u.getGender()); pstmt.setString(5,u.getNation()); pstmt.setString(6,u.getUser_desc()); pstmt.setString(7,u.getID()); number = pstmt.executeUpdate(); } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return number; } /** * @return */ public static ArrayList queryUserList(String condition){ ArrayList userlist=new ArrayList(); ResultSet result=null; try { PreparedStatement pstmt=conn.prepareStatement("select * from t_user where username like ?||'%' order by id"); pstmt.setString(1, condition); result=pstmt.executeQuery(); while(result.next()){ UserForm user=new UserForm(); user.setID(result.getString("id")); user.setUsername(result.getString("username")); user.setPassword(result.getString("password")); Date birth =result.getDate("birthday"); if(birth!=null){ user.setBirthday(birth.toString()); } String gender=result.getString("gender"); if(gender.equals("1")){ user.setGender("男"); }else { user.setGender("女"); } String nation_name=NationDAO.queryNation(result.getString("nation")); user.setNation(nation_name); user.setUser_desc(result.getString("user_desc")); userlist.add(user); } } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return userlist; } /** * @return */ public static UserForm queryUser(String ID){ UserForm user=new UserForm(); ResultSet result=null; try { PreparedStatement pstmt=conn.prepareStatement("select * from t_user where id=?"); pstmt.setString(1, ID); result=pstmt.executeQuery(); if(result.next()){ user.setID(result.getString("id")); user.setUsername(result.getString("username")); user.setPassword(result.getString("password")); Date birth =result.getDate("birthday"); if(birth!=null){ user.setBirthday(birth.toString()); } user.setGender(result.getString("gender")); user.setNation(result.getString("nation")); user.setUser_desc(result.getString("user_desc")); } } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return user; } public static int deleteUser(String [] userID){ int number=0; try { for(int i=0;i<userID.length;i++){ PreparedStatement pstmt=conn.prepareStatement("delete from t_user where id=?"); pstmt.setString(1, userID[i]); number=number+pstmt.executeUpdate(); } } catch (SQLException e) { // TODO 自动生成 catch 块 e.printStackTrace(); } return number; } }