prepstmt.java

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

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