testprep.java

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

import java.sql.*;
public class TestPrep{
	public static void main(String[] args){
	try{
		new oracle.jdbc.driver.OracleDriver();
		Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ora9i","scott","tiger");
		PreparedStatement pstmt=conn.prepareStatement("insert into dept values(?,?,?)");
		for(int i=80;i<90;i++){
			pstmt.setInt(1,i);
			pstmt.setString(2,"Dirk");
			pstmt.setString(3,"10");
			pstmt.addBatch();
		}
		pstmt.executeBatch();
		pstmt.close();
		conn.close();
		}catch(SQLException e){
			System.err.println(e);
		}
	}
}