import java.sql.*;
import javax.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import db.* ;

public class MIDletUserDataUpdateServlet extends HttpServlet 
{
  
	protected void doGet(HttpServletRequest request,HttpServletResponse response)
      		throws IOException, ServletException
	{
		request.setCharacterEncoding("MS950") ;
		String id = request.getParameter("id");
		String pw = request.getParameter("pw");
		String ds = request.getParameter("ds");

		Connection conn = null ;
		Statement stmt = null ;
		DataOutputStream dos = new DataOutputStream(response.getOutputStream());
		response.setContentType("text/plain;charset=UTF-8");
		try
		{
			AccessDAO da = new AccessDAO("enterprisedata") ;
			conn = da.getConnection() ;

			stmt = conn.createStatement() ;
		
			String command = "insert into user values('"+id+"','"+pw+"','"+ds+"')" ;
			int row = stmt.executeUpdate(command) ;
			if(row > 0)
			{
				dos.writeUTF("更新成功："+id+","+pw+","+ds) ;
				dos.flush() ;
			}
			dos.close() ;
			stmt.close() ;
			conn.close() ;	
		}catch(Exception e)
		{
			dos.writeUTF("更新時發(fā)生錯誤"+e) ;
			dos.flush() ;
			dos.close() ;
		}
			
  	}
}	

//取得參數(shù)的方式
//String xxx = request.getParameter("xxx");