myservlet.java

我自己写的一个java tetrix。是上学期的作业

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.util.Properties;

import java.text.*;
import java.util.*;

public class MyServlet extends HttpServlet
{
	public void init() throws ServletException
	{
        try
        {
      		// register driver
      		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    	}
    	catch (Exception e)
    	{
    		System.out.println("Failed to load JDBC/ODBC driver.");
      		return;
    	}

    	try
    	{
      		// make connection
      		con = DriverManager.getConnection("jdbc:odbc:TetrixDB", "", "");
      		//System.out.println("Connected.");
    	}
    	catch (Exception e)
    	{
      		e.printStackTrace();
      	}
    }

    public void destroy()
  	{
		try
		{
			con.close();
    	}
    	catch (Exception e)
    	{
      		e.printStackTrace();
    	}
  	}

public void doGet(HttpServletRequest request,
                    HttpServletResponse response)
  throws IOException, ServletException
  {

	response.setContentType("text/plain");
    PrintWriter out = response.getWriter();

    String []names = new String[10];
    String []scores = new String[10];


    String newpersonname =request.getParameter("newName");

    String newpersonscore =request.getParameter("newScore");

    for(int i=0;i<10;i++)
    {
                 names[i]=null;
                 scores[i]=null;

        }


     //System.setProperty("jdbc.drivers","sun.jdbc.odbc.JdbcOdbcDriver");

     try{

         //connect to the database
         Connection con=DriverManager.getConnection("jdbc:odbc:TetrixDB","","");
         Statement stmt=con.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
        ResultSet rs=stmt.executeQuery("select * from Top10 Order by Score DESC");


            for(int tmp=0;tmp<10;tmp++)
            {
               rs.next();
               names[tmp]=rs.getString(1);

                scores[tmp]=rs.getString(2);
                if(tmp==9)
                {
                   if(Integer.parseInt(scores[9])<Integer.parseInt(newpersonscore))
			      {

                                 rs.moveToCurrentRow();

		           }
			     }


             }



         if(Integer.parseInt(scores[9])<Integer.parseInt(newpersonscore))
	    {
				String command = "DELETE FROM Top10 WHERE Score="+scores[9];

				try
				{
					Statement stmt2 = con.createStatement();
					stmt2.executeUpdate(command);
				}
				catch (Exception e)
				{
					e.printStackTrace();
				}

				command =
					"INSERT INTO Top10 VALUES(" + "'" + newpersonname + "', '" + newpersonscore + "')";
				try
				{
					Statement stmt3 = con.createStatement();
					stmt3.executeUpdate(command);
				}
				catch (Exception e)
				{
					e.printStackTrace();
				}

		}
		rs.close();



         Statement stmt1=con.createStatement();
         ResultSet rs1=stmt1.executeQuery("select * from Top10 Order by Score DESC");

                   		try
		           		{
		           			while (rs1.next())
		 					{
		 						out.println(rs1.getString(1));
                                out.println(rs1.getString(2));
		 					}
		 					rs1.close();
		 				}
				      catch(Exception e){System.out.println("Shit!");}

				      out.close();





        }
            catch( Exception e ) {
              e.printStackTrace();
       }

  }

    public void doPost(HttpServletRequest request, HttpServletResponse response)
  	throws IOException, ServletException
  	{
  		doGet(request, response);
  	}

   	Connection con;
  }