2009-09-17 22:06
package com.custom.data.conn;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
/**
* 链接到资源平台数据库,完成更新\删除\添加\修改功能
* @author wangzi6hao
*
*/
public class ConnCustomSql {
private String sDBDriver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private String url = "jdbc:sqlserver://192.168.1.2:1433;DatabaseName=customerData";// Notice:DatabaseName
private String user = "customerData";
private String password = "sas";// Notice: user and
// password.
Connection conn;
Statement stmt;
ResultSet rs;
public ConnCustomSql() {
try {
Class.forName(sDBDriver).newInstance();
} catch (java.lang.ClassNotFoundException e) {
System.err.println("connsql():" + e.getMessage());
} catch (Exception e) {
e.printStackTrace();
}
}
public boolean executeInsert(String sql) {
boolean isInsert = false;
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
isInsert = true;
} catch (SQLException ex) {
System.err.println("connsql.executeUpdate:" + ex.getMessage());
}
return isInsert;
}
public ResultSet executeQuery(String sql) {
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println("connsql.executeQuery:" + ex.getMessage());
}
return rs;
}
public ResultSet executeQueryUpdate(String sql) {
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println("connsql.executeQuery:" + ex.getMessage());
}
return rs;
}
public boolean executeUpdate(String sql) {
boolean isUpdate = false;
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
isUpdate = true;
} catch (SQLException ex) {
System.err.println("connsql.executeQuery:" + ex.getMessage());
}
return isUpdate;
}
public boolean executeDelete(String sql) {
boolean isDel = false;
try {
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
stmt.executeUpdate(sql);
stmt.close();
conn.close();
isDel = true;
} catch (SQLException ex) {
System.err.println("connsql.executeDelete:" + ex.getMessage());
}
return isDel;
}
public void closeStmt() {
try {
if(null != stmt)
stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void closeConn() {
try {
if(null != conn)
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}