import javax.servlet.ServletException;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import java.sql.*;

public class CheckUserName extends HttpServlet {

public CheckUserName() {

super();

}

public void destroy() {

super.destroy();

}

public void doGet(HttpServletRequest request, HttpServletResponse response)

throws ServletException, IOException {

response.setContentType("text/html");

PrintWriter out = response.getWriter();

//接收数据

String userName=request.getParameter("userName");

        //数据库链接

    try {           Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

    } catch (ClassNotFoundException e1) {

block

e1.printStackTrace();

}      

String jdbcURL="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=news";

Connection conn = null;

try {

conn = DriverManager.getConnection(jdbcURL,"sa","sa");

} catch (SQLException e) {

        e.printStackTrace();

}

PreparedStatement pst;

try {