jdbc问题
11寸 2006-03-19 02:23:19 想要向数据库中插入数据,但没有作用,可是select、create table都好使,就是insert没结果,请高人指点,能不能使其他地方的问题?原程序如下:
public class oraDB {
Connection connect = null;
ResultSet rs = null;
String connectODBC="jdbc:odbc:MOADB";
/**设置驱动程序
*
*
*/
public oraDB(){
try{
//oracle数据库驱动
//Class.forName("oracle.jdbc.driver.OracleDriver");
//access数据库驱动
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){
e.printStackTrace();
}
}
/**
* 执行数据查询
* @param sql 查询语句
* @return rs ResultSet类型
*/
public ResultSet executeQuery(String sql){
try{
//oracle连接语句
//connect = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:MOA","system","root");
//access连接语句
connect = DriverManager.getConnection(connectODBC,"admin","root");
Statement stmt = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(sql);
}
catch(SQLException sqlEX){
sqlEX.printStackTrace();
}
return rs;
}
/**
* 执行数据更新
* @param sql 查询语句
* @return
*/
public int executeUpdate(String sql){
int result = 0;
try{
//oracle连接语句
//connect = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:MOA","system","root");
//access连接语句
connect = DriverManager.getConnection(connectODBC,"admin","root");
Statement stmt = connect.createStatement();
result = stmt.executeUpdate(sql);
}
catch(SQLException sqlEX){
System.err.println(sqlEX.getMessage());
}
return result;
}
/**
* 关闭与数据库的连接
*
*/
public void close(){
if(connect!= null){
try{
connect.close();
connect = null;
}
catch(SQLException sqlEX){
System.err.println(sqlEX.getMessage());
}
}
}
/**
* @param args
*/
public static void main(String[] args) {
// TODO 自动生成方法存根
ResultSet res = null;
int resn;
String sql = new String("");
sql = "insert into col_link values('ASP中华网','http://www.aspcn.com')";
oraDB db = new oraDB();
System.out.println(sql);
resn = db.executeUpdate(sql);
System.out.println(resn);
}
}