server.java

非富多彩的十六个J2ME的例子

import java.io.*;
import java.util.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Server extends HttpServlet
{
	static Connection connection1;
	static ResultSet result1;
	static Statement statement1;
	int record;
	String record_String;
	public void doPost(HttpServletRequest request, HttpServletResponse response )throws IOException, ServletException 
	{
	// Get the input stream and read the data...
	ServletInputStream input_Stream = request.getInputStream();
	DataInputStream d_Inputstream = new DataInputStream(input_Stream );
	String data_MIDlet = d_Inputstream.readUTF();
	d_Inputstream.close();
	try
	{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		connection1 = DriverManager.getConnection("jdbc:odbc:MydataSource","faculty","");
		statement1 = connection1.createStatement();
		result1 = statement1.executeQuery("SELECT Current_Balance from Balance where Pin_No = '" + data_MIDlet + "'");
		if (result1.next())
		{
			record = result1.getInt("current_balance");
			try
			{
				if (connection1!=null) connection1.close();
			}
			catch(SQLException err)
			{
				System.out.println("Error:"+ err);
			}
		}
		else
		{
			record=-1;
		}
	}
	catch(Exception e)
	{
		System.out.println(e);
	}
	record_String = new String(Integer.toString(record));
//	System.out.println("Record: " + record_String);
//	StringTokenizer token = new StringTokenizer(record_String );
//	Vector vector1 = new Vector();
//	while( token.hasMoreTokens() )
//	{
//		vector1.addElement( token.nextToken() );
//	}
	 // Form a response: send back the # of strings
	// followed by each string in turn.
	ByteArrayOutputStream byte_Out =  new ByteArrayOutputStream();
	DataOutputStream data_Out = new DataOutputStream(byte_Out );
	//int size = vector1.size();
//	System.out.println("size: " + size);
//	data_Out.writeInt( size );
//	for( int i = 0; i < size; ++i )
//	{
	data_Out.writeUTF(record_String);  // (String) vector1.elementAt( i ) );
//	}
	byte[] data = byte_Out.toByteArray();
		
//	byte[] data=record_String.getBytes();
//	System.out.println("Record1: " + new String(data));

	// Set the response headers and data...
	response.setContentType("application/octet-stream" );
	response.setContentLength(data.length);
	response.setStatus( response.SC_OK );
	OutputStream out_Stream = response.getOutputStream();
	out_Stream.write( data );
	out_Stream.close();
	}
}