updatedata.java

来自「《Java程序设计与应用》-张仕斌-源程序 《Java程序设计与应用》-张仕斌」· Java 代码 · 共 19 行

import java.sql.*;
public class updatedata{
	public static void main(String args[]){	
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con1=DriverManager.getConnection("jdbc:odbc:JavaDB","Admin","");	
			Statement	smt1=con1.createStatement();
			smt1.executeUpdate("UPDATE employee SET dept='新产品研发中心'  WHERE eid='002'");	
			ResultSet rs1=smt1.executeQuery("select eid,dept from employee");
			System.out.println("工号     部门");
			while (rs1.next()){				
				System.out.println(rs1.getString(1)+"      " +rs1.getString(2));}
			rs1.close();
			smt1.close();
			con1.close();}	
		catch (Exception e){
			e.printStackTrace();}			
	}
}