conn.java

Java Connect DataSource

/*
 * Created on 2004-9-23
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package Conn;
import java.sql.*;
//import java.sql.DriverManager;
//import java.sql.Connection;
//import java.sql.Statement;
//import java.sql.ResultSet;
//import java.lang.*;
//import java.io.*;
/**
 * @author administrator
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class Conn 
{
	public static void main(String[] args) throws SQLException
	{
		String Query="select * from Table order by field1 desc";
		String ss = "";
		Connection conn = jdbc.getConn();
		Statement stmt = conn.createStatement();		
		ResultSet RS = stmt.executeQuery(Query);
		while(RS.next())
		{
			ss = RS.getString("field2");
			System.out.println(ss);
		}		
	}		
}