select.java

来自「B/S架构的软件项目实训；包括全部详细文档合源程序」· Java 代码 · 共 44 行

import java.sql.*;
import java.io.*;
class Select  
{	
	public static void main(String[] args) 	
	{	  
		try		
		{		   
			String acNo="A00001";
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");	    
			Connection conn=DriverManager.getConnection("jdbc:odbc:test");	
			Statement stmt=conn.createStatement();		 
			String strQuery="select * from AccountInfo where accountNo='"+acNo+"'";	
			ResultSet rs=stmt.executeQuery(strQuery);
			while(rs.next())		
			{			
				String name=rs.getString("ownerName");			
				float balance=rs.getFloat("balance");			
				String acType=rs.getString("accountType");			
				String branch=rs.getString("branch");			
				String ID=rs.getString("idNo");			
				String addr=rs.getString("address");
				String wPhone=rs.getString("phone");			
				String email=rs.getString("email");	
				
				System.out.println("帐号："+acNo);			
				System.out.println("姓名："+name);			
				System.out.println("余额："+balance);			
				System.out.println("帐户类型："+acType);			
				System.out.println("分支机构:"+branch);			
				System.out.println("身份证号码："+ID);			
				System.out.println("地址："+addr);			
				System.out.println("单位电话："+wPhone);			
				System.out.println("电子邮箱："+email);
			}
			conn.close();	 
		}
		catch(Exception e){System.out.print(e);}	
	}
}