package mydb;
import java.sql.*;public class mydb {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:sunshine";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public mydb() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("mydb(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
stmt = null;
rs=null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}将他存为.java然后在解释成.class就行了
import java.sql.*;public class mydb {
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:sunshine";
private Connection conn = null;
private Statement stmt = null;
ResultSet rs = null; public mydb() {
try {
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e) {
System.err.println("mydb(): " + e.getMessage());
}
}
public ResultSet executeQuery(String sql) {
rs = null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
return rs;
}
public void executeUpdate(String sql) {
stmt = null;
rs=null;
try {
conn = DriverManager.getConnection(sConnStr);
stmt = conn.createStatement();
stmt.executeQuery(sql);
stmt.close();
conn.close();
}
catch(SQLException ex) {
System.err.println("aq.executeQuery: " + ex.getMessage());
}
} public void closeStmt(){
try{
stmt.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
public void closeConn(){
try{
conn.close();
}
catch(SQLException e){
e.printStackTrace();
}
}
}将他存为.java然后在解释成.class就行了
解决方案 »
- 我笔记本是AMD A4-3300M 用Myeclipse8.5总是很卡 而且我已经优化过了
- 高手快进来救人呐!
- javascript的window.scroll怎么用啊,我为什么老是用不好,高手进啊,
- [急!!]HTTP Status 404 突然出现!所有的办法都试过,20分求解!
- jfreechart TimeSeriesChart 时间只取月份要如何办到?
- 连接DB2数据库出现"encoding not supported!!"错误
- 如何取得mysql数据库中的Datetime 类型的值,并在jsp页中将它转化为String输出?
- 请问有什么方法能从一个窗体中指定另一个窗体刷新?
- 急!到底要多少内存WS+DB2才能跑起来?
- 大虾帮忙,怎样用JDBC-ODBC连接SQL2000并使用呀?
- 我想在oracle上插入4000字的文字,请问该用什么样的字段,用varchar2能行吗
- Tomcat3.2找不到servlet!!很急!在线等待
http://www.csdn.net/expert/topic/670/670716.xml?temp=.7412226
sqlserver。