datasourcetestservlet.java

< J2EE应用开发详解>>一书全部的源代码. 本书基于J2EE 1．4平台

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);
	}
}