selectdelete全都好用唯独insert不好用也不报错执行完毕数据库里一点东西也没添加发高手帮忙看下啊!!!importjava.sql.*;publicclassdb{publicstaticvoidmain(String[]args){try{St...
select delete 全都好用 唯独insert 不好用 也不报错 执行完毕 数据库里一点东西也没添加 发高手帮忙看下啊!!!
import java.sql.*;
public class db {
public static void main(String[] args) {
try{
String sql ="delete from stu where id=2";
String sqlselect = "select * from stu";
String sqlinsert = "INSERT into stu(id,nme) values(6,'s')";
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=E:\\student.mdb";
Connection conn = DriverManager.getConnection(url,"","");
Statement stml = conn.createStatement();
int i = stml.executeUpdate(sql);
ResultSet rs = stml.executeQuery(sqlselect);
while(rs.next()){
System.out.println(rs.getString(1)+" "+rs.getString(2)+" "+rs.getString(3)+" "+rs.getString(4));
}
i=stml.executeUpdate(sqlinsert);
System.out.println(i);
}catch(Exception e){
e.printStackTrace();
System.out.println("数据库不能打开 ");
}
}
}
展开