?? testjdbc.java
字號(hào):
import java.sql.*;
import java.io.*;
public class TestJdbc {
public static void main(String[] args) {
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;//結(jié)果集
String dbdriver ="oracle.jdbc.driver.OracleDriver";
try{
Class.forName("oracle.jdbc.driver.OracleDriver");//加載驅(qū)動(dòng)
}
catch (Exception e)//捕捉異常
{
System.err.println("Error! " + e.getMessage());
System.err.println("Please install JDBC-ODBC Driver first.");
return;
}
System.out.println("dbdriver succeed");
// *********************************************************************************************
String strUser = "scx";
String strPass = "bnm123" ;
String url ="jdbc:oracle:thin:@127.0.0.1:1521:XE";//連接串
try{
conn = DriverManager.getConnection(url, strUser, strPass); //啟動(dòng)連接
System.out.println("connect succeed");
stmt=conn.createStatement();//
rs = stmt.executeQuery ("select * from student");//查詢數(shù)據(jù)庫(kù)列表
while (rs.next())//遍歷
{
System.out.println(rs.getString("sno")+rs.getString("sname"));
}
}catch(Exception e){ e.printStackTrace(); }
//***************************************************************************************
try
{
stmt.executeUpdate("insert into student values('004','SCX')");//增加
}
catch(SQLException e){ System.err.println("executeInsert:"+e.getMessage()); }
System.out.println("insert succeed");
// *********************************************************************************************
try
{
stmt.executeUpdate("update student set sname='master' where sno='001'");//更新
}
catch(SQLException e){ System.err.println("executeUpdate:"+e.getMessage()); }
System.out.println("update succeed");
// ***********************************************************************************************
try
{
stmt.executeUpdate("delete from student where sno='002'");//刪除
}
catch(SQLException e){ System.err.println("executeDelete:"+e.getMessage()); }
System.out.println("delete succeed");
// **********************************************************************************************
try
{
rs = stmt.executeQuery ("select * from student");//查詢
while (rs.next())
{
System.out.println(rs.getString("sno")+rs.getString("sname"));
}
rs.close();
conn.close();
}catch(Exception e){ e.printStackTrace(); }
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -