package jsp;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

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

public class csvp {
	private String username;
	public String getUsername() {
		return username;
	}

	public void setUsername(String username) {
		this.username = username;
	}



	public String x;
	
	public csvp(){
		
		
	}
	
	
	
	
	public String receive(){
		
		try {Context initCtx = new javax.naming.InitialContext(); 
		Context envCtx = (Context) initCtx.lookup("java:comp/env"); 
		DataSource ds;
			ds = (DataSource)envCtx.lookup("jdbc/mysql");
		
		try {Connection con =  ds.getConnection();
		Statement stmt;
			stmt = con.createStatement();
		String sql="Select * from user" ;
		System.out.println(sql);
		ResultSet rs= stmt.executeQuery(sql);
		
		
		x="";
		if (!rs.next()){x="���޴���";}else{
			rs.beforeFirst();
	while (rs.next()){
	
		//x+=rs.getString(2);
		
		 		x+= rs.getRow()+",";
		 		x+=rs.getString(2)+",";
		 				x+=rs.getString(3)+"\n";
		 						
	}
		}
	
		rs.close();
		stmt.close();
		con.close();
		} catch (SQLException e) {
			// TODO �Զ���ɵ� catch ��
			e.printStackTrace();
		}
		} catch (NamingException e) {
			// TODO �Զ���ɵ� catch ��
			e.printStackTrace();
		} ;
		System.out.println(x);
		return x.trim();
		
		
		}
}