?? jdbc.java
字號(hào):
import java.sql.*;
class jdbc {
public static void main(String args[]) throws Exception{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * FROM MyTable");
System.out.println("顯示結(jié)果:");
while(rs.next())
{
int i=rs.getInt("ID");
String studentnum=rs.getString("學(xué)號(hào)");
String name=rs.getString("姓名");
int age=rs.getInt("年齡");
System.out.println(i+" "+studentnum+" "+name+" "+age);
}
//stmt.executeUpdate("UPDATE test set name='xz' where id=1");
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -