testjdbc.java

来自「这是一个关于jsp的学习文档.为学习jsp的朋友提供方便」· Java 代码 · 共 26 行

import java.sql.*;

public class TestJDBC{
	public static void main(String[] args) {
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");  //注册驱动程序 
			Connection con = DriverManager.getConnection("jdbc:odbc:sql", "", "");  
			Statement stmt = con.createStatement();
			ResultSet  rs  =  stmt.executeQuery("select * from view1");
			while(rs.next()){
					System.out.print("\t编号：" + rs.getString(1));
					System.out.print("\t性别：" + rs.getString(2));
					//System.out.print("\t年龄：" + rs.getInt(3));
					//System.out.print("\t性别：" + rs.getInt(4));
					//System.out.print("\t生日：" + rs.getDate(6));
					System.out.println();
			}
			rs.close();
			stmt.close();
			con.close();	    
		}catch(Exception e){
		    e.printStackTrace();
		}
	}	
}