webTest-(2).zip_上传图片_图片上传

package com.icss.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; public class DBFactory { private Connection conn = getConnection(); private Connection getConnection() { try { Class.forName("net.sourceforge.jtds.jdbc.Driver"); conn = DriverManager.getConnection( "jdbc:jtds:sqlserver://localhost:1433/test", "sa", ""); } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return conn; } public void execSqlWithoutResultset(String sql, Object[] params) { try { if (conn == null) getConnection(); PreparedStatement pstmt = conn.prepareStatement(sql); for (int i = 0; i < params.length; i++) { pstmt.setObject(i + 1, params[i]); } pstmt.execute(); close(); } catch (SQLException e) { e.printStackTrace(); } } public ResultSet execSqlWithResultset(String sql, Object[] params) { ResultSet rs = null; try { if (conn == null) getConnection(); PreparedStatement pstmt = conn.prepareStatement(sql); for (int i = 0; i < params.length; i++) { pstmt.setObject(i + 1, params[i]); } rs = pstmt.executeQuery(); } catch (SQLException e) { e.printStackTrace(); } return rs; } public void close() { try { if (conn != null) conn.close(); } catch (SQLException e) { e.printStackTrace(); } finally { conn = null; } } }