jdbctest.java

来自「j2EE」· Java 代码 · 共 34 行

import java.sql.*;


class JdbcTest
{
	public static void main(String args[])
	{
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e)
		{
			System.out.println(e);
		}

		try{
			String url = "jdbc:odbc:test";
			Connection con = DriverManager.getConnection(url);
			Statement s = con.createStatement();

			ResultSet rs = s.executeQuery("Select * from Employee");
		
			while(rs.next())
			{
				System.out.print(rs.getString(1)+"\t");
				System.out.print(rs.getString(2)+"\t");
				
			}
		}catch(SQLException e)
		{
			System.out.println(e);
		}
	}
}