package DBconn;

import java.sql.Connection;
import java.sql.SQLException;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class DButil {
	private static DataSource getsource(){
		DataSource source = null;
		try {
			Context context=new InitialContext();
			source=(DataSource)context.lookup("java:comp/env/wsjtangy");
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return source;
	}
public static void main(String [] args){
	String sql = "select * from users";
	Connection conn = null;
	java.sql.ResultSet rs=null;
	java.sql.PreparedStatement ps=null;
	try {
		conn=getsource().getConnection();
		ps=conn.prepareStatement(sql);
		rs=ps.executeQuery();
		while(rs.next()){
			 System.out.println("数据库内容："+rs.getString("username"));
		}
	} catch (SQLException e) {
		// TODO Auto-generated catch block
		e.printStackTrace();
	}
	
}
}