第3个回答 2013-10-18
package cn.com.csuinfo.work.util;import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Vector;/**
* 完成基本的增删改查功�1�7?,�1�7?有的dao都必须继承该父类
*
* @author lhb
*
*/
public class ORCZFBasicDao {
private DBConnection db = DBConnection.getDBConnection(); /**
* 数据库的修改操作(insert,update,delete)
*
* @param executeSql
* :要操作的sql语句;
* @param paramValues
* :动�1�7?�1�7sql中的参数列表�1�7?
*/
public boolean updateZfSystem(String sql, Object[] values) throws Exception {
boolean flag = false;// 默认为操作失�1�7?
Connection conn = null;
PreparedStatement pstmt = null; try {
conn = db.getConnection();
pstmt = conn.prepareStatement(sql);
// 判断执行的sql是否有参�1�7?
if (values != null) {
int i = 1;
for (Object value : values) { pstmt.setObject(i++, value);
}
}
int row = pstmt.executeUpdate();
if (row > 0) {
flag = true;
}
} catch (Exception ex) {
ex.printStackTrace();
flag = false;
} finally {
db.closeDBResource(conn, pstmt, null);
return flag;
}
} /**
* �0�1�1�7�1�7�0�9�0�5�1�7�1�7
*/
public Vector queryZfSystem(String str, Object[] values)
throws Exception {
Vector vector = new Vector(); ResultSet result = null;
Connection conn = null;
PreparedStatement pstmt = null;
try {
conn = db.getConnection();
pstmt = conn.prepareStatement(str);
// 判断执行的sql是否有参�1�7?
if (values != null) {
int i = 1;
for (Object value : values) {
pstmt.setObject(i++, value);
}
}
result = pstmt.executeQuery();
while(result.next()) {
vector.add(result.getString(1));
} } catch (Exception ex) {
ex.printStackTrace(); } finally { return vector;
} } public Vector<String> doSelectOne(String sql, Object[] values, int column) { Vector inFoVector=null;
Connection conn = db.getConnection();
Statement st = null;
ResultSet rs = null;
PreparedStatement pstmt = null;
try {
conn = db.getConnection();
pstmt = conn.prepareStatement(sql);
// 判断执行的sql是否有参�1�7?
if (values != null) {
int i = 1;
for (Object value : values) {
pstmt.setObject(i++, value);
}
}
rs = pstmt.executeQuery(); if (rs.next()) {
inFoVector = new Vector();
for (int i = 1; i <= column; i++) {
inFoVector.add(rs.getString(i));
} } else {
System.out.println(rs == null);
} } catch (Exception e) { } finally {
db.closeDBResource(conn, pstmt, rs);
}
return inFoVector;
}
}