parseldata.java

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

import java.sql.*;
public class parseldata{
	public static void main(String args[]){	
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			Connection con1=DriverManager.getConnection("jdbc:odbc:JavaDB","Admin","");	
			PreparedStatement smt1=con1.prepareStatement("select eid,ename from employee where eid=?");     
			smt1.setString(1,"002");
			ResultSet rs1=smt1.executeQuery();
			System.out.println("工号     姓名");
			if (rs1.next()){				
				System.out.println(rs1.getString(1)+"      " +rs1.getString(2));}
			rs1.close();
			smt1.close();
			con1.close();}	
		catch (Exception e){
			e.printStackTrace();}			
	}
}