queryodbctest.java

编程之道--java程序设计入门源代码

/**
 * 通过这个程序，向读者展示比较完整的JDBC数据库操作的顺序，在这个例子中主要展示的查询
 * 及格式输出。
 */

import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet; 
import java.sql.DriverManager;
import java.sql.Date;

public class QueryODBCTest
{
	private Connection con;
	
	public static void main(String[] args)
	{		
		QueryODBCTest test = new QueryODBCTest();
		Connection con = test.getConnection();
		String sql = "select * from student";
		test.getStudent(con, sql);
		
	}
	
	public void getStudent(Connection con, String sql)
	{
		try
		{
			Statement st = con.createStatement();
			ResultSet rs = st.executeQuery(sql);
			
			while(rs.next())
			{
				String name =rs.getString("姓名");
				String number = rs.getString("学号");
				Date date = rs.getDate("出生日期");
				String spe = rs.getString("专业");
				String address = rs.getString("籍贯");
				
				System.out.println( "\n姓名:" + name + "\t学号:" + number + 
									"\t出生日期:" + date + "\t专业:" +
									spe + "\t籍贯:" + address ); 				
			}
			
			st.close();
			con.close();			
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
	}

	public Connection getConnection()
	{
		String url = "jdbc:odbc:myAccess";//数据库URL
		String userName = "";//登录数据库用户名
		String password = "";//用户密码
		
		try
		{
			//登录JDBC-ODBC驱动程序
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con = DriverManager.getConnection(url, userName, password);
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
		catch(ClassNotFoundException ex)
		{
			ex.printStackTrace();
		}
		
		return con;
	}
}