import java.lang.*;
import java.io.*;
import java.sql.*;
class HelloWorld{
public static void main(String args[])throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String sourceURL="jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ="
+("a.mdb");
Connection databaseConnection=DriverManager.getConnection(sourceURL);
Statement st=databaseConnection.createStatement();
//String sql="Insert INTO abc ";
//String sql="UPDATE abc SET name='woaini'"+"WHERE id=2";//modify the list
//String sql="DELETE FROM abc "+"WHERE id=2";
String sql="INSERT INTO abc"+"(id,num,name)"
+"VALUES(8,678,'hehe')";// "+"WHERE id=2";
int i=st.executeUpdate(sql);
String getString="SELECT * FROM abc ";
//String getString="Select id,num,name FROM abc WHERE id=2";
int id,num;
String name;
ResultSet rs=st.executeQuery(getString);
while(rs.next()){
id=rs.getInt("id");
num=rs.getInt("num");
name=rs.getString("name");
System.out.println(id+" "+num+" "+name);
}
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载