package com.j2ee14.ch7;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
import com.j2ee14.util.*;
public class DataSourceTestServlet extends javax.servlet.http.HttpServlet
{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{
	    response.setContentType("text/html");
        PrintWriter out = response.getWriter();
        try
        {
        	Connection con=DatabaseConn.getConnection();
        	Statement stmt=con.createStatement();
        	stmt.execute("create table account(id int not null,name varchar(20))");
			stmt.execute("insert into account values(1,'dfdf')");
			ResultSet rst=stmt.executeQuery("select * from account ");
            while(rst.next())
            {
            	out.println(rst.getInt("id"));
            	out.println(rst.getString("name"));
            }
            	
        	stmt.close();
        	con.close();       	
        	
        }
        catch(Exception e)
        {
        	e.printStackTrace();
        }
        
    }
    public void doPost(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{
		doGet(request,response);
	}
}