querystudent.java

来自「主要是对于JAVA的编程的基本语言 希望能够帮得上你。」· Java 代码 · 共 48 行

package exercise;

import java.sql.*;
import java.io.*;

public class QueryStudent {

	public static void main(String[] args) {		
		
		String name="";	
		try {
				//安装驱动程序
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				//创建数据库连接
				Connection conn=DriverManager.getConnection("jdbc:odbc:student");
				//创建SQL语句
				Statement stmd=conn.createStatement();
				
				System.out.print("输入姓名：");
				BufferedReader br=new BufferedReader(new InputStreamReader
						(System.in));
				try {
					name =br.readLine();
				} catch (IOException e) {					
					e.printStackTrace();
				}				
				//执行SQL语句，返回结果集
				ResultSet rs=stmd.executeQuery("select * from studentbase where 姓名='"+name+"'");
				if(!rs.next()){
					System.out.println("查无此人！");
				}else{
					do{
						System.out.println(rs.getLong("学号")+" "+rs.getString("姓名")
							+" "+rs.getInt("年龄")+" "+rs.getString("性别")+" "
							+rs.getString("系名"));
					}while(rs.next());
				}			

			} catch (ClassNotFoundException e) {				
				System.err.println(e.getMessage());
			} catch (SQLException e) {				
				System.err.println(e.getMessage());
			}
					
		
	}
}