public static void insertDep(int department_id String department_name, float salary, int location_id){
[color=red](1)调用JDBC的环境构架 [/color]
Connection con=DMmanager.getConnection();
PreparedStatement pst=null;
String str="insert into department values(?,?,?,?)";
pst = con.prepareStatement(str)
[color=red](2)PreparedStatement类的对象pst的SetIn方法,将insert中的values赋值给pst中的域变量[/color]
pst.setInt(1,department_id);
pst.setString(2,department_name);
pst.setFlaot(3,salary);
pst.setInt(4,location_id)
[color=red](3)执行[/color]
pst.executeUpdate();
[color=red] (4)关闭[/color]
pst.close();
con.close();
}
PS: I am junior in Java, Look forward to your guys comments and correction,Thanks.
[color=red](1)调用JDBC的环境构架 [/color]
Connection con=DMmanager.getConnection();
PreparedStatement pst=null;
String str="insert into department values(?,?,?,?)";
pst = con.prepareStatement(str)
[color=red](2)PreparedStatement类的对象pst的SetIn方法,将insert中的values赋值给pst中的域变量[/color]
pst.setInt(1,department_id);
pst.setString(2,department_name);
pst.setFlaot(3,salary);
pst.setInt(4,location_id)
[color=red](3)执行[/color]
pst.executeUpdate();
[color=red] (4)关闭[/color]
pst.close();
con.close();
}
PS: I am junior in Java, Look forward to your guys comments and correction,Thanks.