insertdata.java

《Java程序设计与应用》-张仕斌-源程序 《Java程序设计与应用》-张仕斌-源程序

import java.sql.*;
public class insertdata{
	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.execute("INSERT INTO employee VALUES('003','辛晓晓','女','人事部',550)");
			ResultSet rs1=smt1.executeQuery("select eid,ename,dept from employee");
			System.out.println("工号     姓名      部门");
			while (rs1.next()){				
				System.out.println(rs1.getString(1)+"      " +rs1.getString(2)+"      " +rs1.getString(3));}
			rs1.close();
			smt1.close();
			con1.close();}	
		catch (Exception e){
			e.printStackTrace();}			
	}
}