database.java

java实现数据库的连接,一个简单的例子,但是却实现了与数据库的交互

import java.sql.*; 

class database { 
public static void main(String args[]) { 
try{ 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
String url="jdbc:odbc:MyData"; 
Connection connection=DriverManager.getConnection(url); 
Statement statement = connection.createStatement(); 
String sql="SELECT * FROM table1 "; 
ResultSet rs = statement.executeQuery(sql); 
//String tt; 
while (rs.next()) { 
System.out.print("姓名:" + rs.getString("Name")); 
System.out.println(" 年龄:" + rs.getString("Age")); 
} 
rs.close(); 
connection.close(); 
} 
catch(Exception ex){ 
System.out.println(ex); 
System.exit(0); 
} 
} 
}