jdbcexample.java

JDBC,指定数据库,打开数据库连接 数据库查询、修改、增加或删除等

import java.sql.*;
public class JdbcExample{
    public static void main(String args[]){
		String serverName = "localhost";
		try{
		    //Class.forName("oracle.jdbc.driver.OracleDriver");
		    System.setProperty("jdbc.drivers","oracle.jdbc.driver.OracleDriver");
		    String url="jdbc:oracle:thin:@"+serverName+":1521:ora9i";
		    Connection conn=DriverManager.getConnection(url,"scott","tiger");
		    Statement stmt=conn.createStatement();
		    ResultSet rs=stmt.executeQuery("select * from dept");
		    while(rs.next()){
				System.out.print("DeptNo: "+rs.getInt(1));
				System.out.print("\tDeptName: "+rs.getString(2));
				System.out.println("\tLOC: "+rs.getString(3));
			}
			rs.close();
			stmt.close();
			conn.close();
		}catch(Exception e){
		    e.printStackTrace();
		}
    }
}