package oracledemo;
import java.sql.*;
import java.util.Scanner;
import javax.sql.*;
public class moxie0926 {
/**
* @param args
*/
public static void main(String[] args) {
Scanner input=new Scanner(System.in);
System.out.print("请输入部门编号:");
int deptnos=input.nextInt();
System.out.print("请输入部门名称:");
String dnames=input.next();
System.out.print("请输入部门所在城市:");
String locs=input.next();
try {
//1.加载驱动
Class.forName("oracle.jdbc.OracleDriver");
//2.建立连接对象
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl","scott","123456");
//3.创建命令语句对象
PreparedStatement pstmt=con.prepareStatement("insert into dep