sqltest.java.bak

用java实现对数据库的连接

import java.sql.*;

public class SQLTest
{
	public static void main(String[] args)
	{
		String data="jdbc:odbc:score";
		try{
		    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		    Connection con=DriverManager.getConnection(data,"","");
		    Statement st=con.createStatement();
		    ResultSet rec=st.executeQuery(
		                  "SELECT * "+
		                  "FROM test "+
		                  "WHERE "+
		                  "(name=*) "+
		                  "ORDER BY score");
		     System.out.println("name\tnum\tscore\t");
		     while(rec.next()){
		        System.out.println(rec.getString(1)+"\t"
		                          +rec.getString(2)+"\t"
		                          +rec.getString(3));  
		     } 
		     st.close();                  
	           }
	           catch (SQLException s)
	           {
	           	System.out.println("SQL Error: "+s.toString()+""+s.getErrorCode()+""+s.getSQLState());
	           }
	           catch (Exception e)
	           {
	           	System.out.println("Error");
	           }
	}
}