?? updateaccess.java
字號:
//updateaccess.java:更新Access數據庫
import java.sql.*;
class updateaccess{
public static void main (String args[]) throws Exception{
Connection con;
Statement stmt;
try{
//Load JDBC driver
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
//注意DBQ的寫法
String url = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=C:\\jdk1.3.1\\javaprograms\\jdbc.mdb";
con = DriverManager.getConnection(url,"sa","");
stmt = con.createStatement();
String update = "update userInfo set tel = '12345678' where name = 'bi' ";
int result = stmt.executeUpdate(update);
if ( result > 0 )
{
System.out.println("update success!");
} else{
System.out.println("update fail!");
}
//close db
try{
if(!con.isClosed())
con.close();
}catch(SQLException err){
System.err.println(err.toString());
}
}
catch( Exception e ){
e.printStackTrace();
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -