小dao
package dao;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Conn {
String sDBDriver = "com.ibm.db2.jcc.DB2Driver";//需要将license加入到classpath中
String sConnStr = "jdbc:db2:NORI";//NORI是数据库名
String username = "userid";
String password = "password";
Connection connection = null;
ResultSet rs = null;
public Conn() {
try {
Class.forName(sDBDriver);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public ResultSet executeQuery(String sql) {
try {
connection = DriverManager.getConnection(sConnStr, username,
password);
Statement stmt = connection.createStatement();
rs = stmt.executeQuery(sql);
return rs;
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}
public void executeUpdate(String sql) {
try {
connection = DriverManager.getConnection(sConnStr, username,
password);
Statement stmt = connection.createStatement();
int num = stmt.executeUpdate(sql);
System.out.println("you hava operated " + num + " lines!");
} catch (SQLException e) {
e.printStackTrace();
}
}
public void close(){
if(rs!=null){
rs = null;
}
if(connection!=null){
try{
connection.close();
}catch(SQLException e){
e.printStackTrace();
}
}
}
}
页:
[1]