?? jdbctest.txt
字號(hào):
import java.sql.*;
public class JdbcTest
{
public static void main(String[] args)
{
String url="jdbc:odbc:Mydatasource";
Connection con=null;
Statement sm=null;
ResultSet rs=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(Exception e)
{
e.printStackTrace();
}
try
{
con=DriverManager.getConnection(url);// 實(shí)際上,我們可以將這個(gè)程序?qū)懗筛话愕男问剑床辉诔绦蛑泄潭ㄓ媚囊环N驅(qū)動(dòng)程序,
//不固定uRL、用戶名和口令,而是把它們作為參數(shù),在程序執(zhí)行曲時(shí)候由用戶輸入see Page96
sm=con.createStatement();
//sm.executeUpdate("INSERT INTO Test " + "VALUES (001,'mary')");//It's strange that there must be a blank after the table name!
sm.executeUpdate("insert into 操作員 " + "values('005','xiangxiang',' ','005',' ',' ')");
rs=sm.executeQuery("SELECT* FROM 操作員 WHERE 狀態(tài) LIKE '在職'");
while(rs.next())
{
String opID=rs.getString(1);
String opName=rs.getString(2);
System.out.println("操作員ID:"+opID);
System.out.println("操作員姓名:"+opName);
}
}catch(SQLException ex)
{
ex.printStackTrace();
}
finally
{
try
{
rs.close();
sm.close();
con.close();
}catch(SQLException ex)
{
ex.printStackTrace();
}
}
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -