SSI（struts2+ibatis+spring）

package test; import java.io.UnsupportedEncodingException; import java.lang.reflect.Method; import java.sql.Connection; import java.sql.Date; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import java.util.Map; import java.util.Timer; import java.util.TimerTask; import javax.servlet.http.HttpServletRequest; import org.dom4j.Document; import com.common.Dom4JParseXml; import com.common.PathTool; /** * 单例模式 * @author panzhipeng */ public class JdbcTool { // 1、私有的静态的类的实例 private static ThreadLocal<Connection> threadLocal = new ThreadLocal<Connection>(); private static JdbcTool INSTANCE = null; private static Connection connect = null; //2、私有的构造方法 public JdbcTool(){ } //3、公有的静态的同步 工厂方法 public static synchronized JdbcTool getInstance() { if (null == INSTANCE) { INSTANCE = new JdbcTool(); connect=getConnection(); } return INSTANCE; } // 4、重写clone方法 @Override protected Object clone() throws CloneNotSupportedException { return getInstance(); } /** * 执行DDL语句 * @return */ public boolean extecuteDDL(Connection connection) { return false; } // public List<?> careLogin00(String username,String password){ // List<?> list=null; // Connection connect = null; // try{ // connect=this.getConnection(); // String selectSql="SELECT * FROM personal WHERE username=? and password=?"; // Object[] params = new Object[]{username,password}; // ResultSet rs = this.executePreparedQuery(connect, selectSql, params); // list=this.parseResultset2List(rs, userinformation.class); // // } // catch(Exception exception){ // exception.printStackTrace(); // }finally{ // closeConnection(connect); // } // return list; // } //根据用户名得到结果集 public static List<?> careLogin0(String username,Class<?> clazz){ List<?> list=null; String tableName = clazz.getSimpleName(); //获取类名.不带包名 try{ getInstance(); String selectSql="SELECT * FROM "+tableName+" WHERE username=? "; Object[] params = new Object[]{username}; ResultSet rs = executePreparedQuery(selectSql, params); list=parseResultset2List(rs,clazz); } catch(Exception exception){ exception.printStackTrace(); } return list; } //根据用户名得到结果集 public List<?> careLogin01(String username,Class<?> clazz){ List<?> list=null; String tableName = clazz.getSimpleName(); //获取类名.不带包名 try{ getInstance(); String selectSql="SELECT * FROM "+tableName+" WHERE username like ? "; Object[] params = new Object[]{username}; ResultSet rs = executePreparedQuery(selectSql, params); list=parseResultset2List(rs,clazz); } catch(Exception exception){ exception.printStackTrace(); } return list; } //根据用户名和密码得到结果集 public List<?> careLogin00(String username,String password,Class<?> clazz){ List<?> list=null; String tableName = clazz.getSimpleName(); //获取类名.不带包名 try{ getInstance(); String selectSql="SELECT * FROM "+tableName+" where username=? and password=?"; Object[] params = new Object[]{username,password}; ResultSet rs =executePreparedQuery(selectSql, params); list=parseResultset2List(rs,clazz); } catch(Exception exception){ exception.printStackTrace(); } return list; } public static void dumpResultSet(ResultSet resultSet) { if(resultSet != null) { try { ResultSetMetaData metaData = resultSet.getMetaData(); // 结果集有几列 // 结果集有几列 int num = metaData.getColumnCount(); while (resultSet.next()) { for (int i = 1; i <= num; i++) { System.out.println(resultSet.getObject(i) + "\t"); } System.out.println("---------------"); } } catch (Exception e) { e.printStackTrace(); } } } //得到用户名 public String strusername(){ String username=null; ResultSet rs; try { String sql="select username from personal "; getInstance(); Object[] params=new Object[]{}; rs=executePreparedQuery(sql, params); if(rs.next()){ username=rs.getString(1); } } catch (SQLException e) { e.printStackTrace(); } return username; } //得到锁定值 public static int initLock(String username){ int onlock=0; ResultSet rs; try { String sql="select onlock from personal where username=?"; getInstance(); Object[] params=new Object[]{username}; rs=executePreparedQuery(sql, params); if(rs.next()){ onlock=rs.getInt(1); } } catch (SQLException e) { e.printStackTrace(); } return onlock; } //得到登录次数 public static int initTimes(String username){ int times=1; ResultSet rs; try { String sql="select times from personal where username=?"; getInstance(); Object[] params=new Object[]{username}; rs=executePreparedQuery(sql, params); if(rs.next()){ times=rs.getInt(1); } } catch (SQLException e) { e.printStackTrace(); } return times; } //登录次数+1 public static void initTimesadd(String username){ try { String sql="update personal set times=times+1 where username=?"; getInstance(); Object[] params=new Object[]{username}; executePreparedUpdate(sql, params); } catch (Exception e) { e.printStackTrace(); } } //成功 times 置1 public static void initTimes00(String username){ try { String sql="update personal set times=1 where username=?"; getInstance(); Object[] params=new Object[]{username}; executePreparedUpdate(sql, params); } catch (Exception e) { e.printStackTrace(); } } // 调用 所有对象顺便 遍历 public static <T> List<T> parseResultset2List(ResultSet resultSet, Class<T> clazz) { List<T> list = new ArrayList<T>(); // 判断结果集是否为空 if (null == resultSet) { return list; } try { // 1、获取ResultSetMetaData ResultSetMetaData metaData = resultSet.getMetaData(); // 2、获取列名 int num = metaData.getColumnCount(); String [] columnNames = new String[num]; for (int i = 0; i < num; i++) { columnNames[i] = metaData.getColumnName(i + 1); } Method [] methods = clazz.getDeclaredMethods(); // 3、处理结果集,遍历每一行记录 while (resultSet.next()) { T t = clazz.newInstance(); // 实例化对象 // 遍历每一行的所有列，把每一列的值设置到我们对象的属性中 for (int i = 0; i < num; i++) { String columnName = columnNames[i]; String methodName = "set" + columnName; for (Method setMethod : methods) { // 如果找到对应的set方法 if (methodName.equalsIgnoreCase(setMethod.getName())) { // javaBean的属性的类型 String fieldTypeName = setMethod.getParameterTypes()[0].getName(); // 数据库中列的类型 String columnTypeName = resultSet.getObject(columnName).getClass().getName(); if (!fieldTypeName.equals(columnTypeName)) { continue; //继续下一个循环 } setMethod.invoke(t, new Object[]{resultSet.getObject(columnName)}); break; } } } list.add(t); } } catch (Exception e) { e.printStackTrace(); } return list; } /** * 执行批量处理 * @return */ public boolean executeBatch(Connection connection) { return false; } public static ResultSet executePreparedQuery( String sql, Object[] params) {