deleteassign.java

由javascript调用serlet后台程序

package com.blog;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;


import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;


public class  deleteAssign extends HttpServlet {
    
	public void init(ServletConfig config) throws ServletException {
    }
    
    /*
     *  处理<GET> 请求方法.
     */
    protected void doGet(HttpServletRequest request, HttpServletResponse response)
    throws ServletException, IOException {
    	//设置接收信息的字符集
    	request.setCharacterEncoding("UTF-8");
    	//接收浏览器端提交的信息
		String value = request.getParameter("number");
		System.out.print(value);
		System.out.print("123456");
         int id=Integer.parseInt(value);
	System.out.print("bingo");

      

                String sql="delete from  Assignment  where AssignmentID="+id;
				System.out.print(sql);
		
		//设置输出信息的格式及字符集        
      
        //创建输出流对象
        PrintWriter out = response.getWriter();
        /*
         *检查用户名，并输出结果 
         */
		Connection conn = null;
	        Statement  stat = null;
                ResultSet  rs = null;
	
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		catch(ClassNotFoundException e){
	
		}
		try{
			conn = DriverManager.getConnection("jdbc:odbc:myblog","","");
			stat = conn.createStatement();
		}
		catch(SQLException e){
			
		}

	try{
	       stat.executeUpdate(sql);

		   out.println("0");

		out.close();

		
       }
catch (SQLException e){
}
    }
}