checkname.jsp

智能文档检索系统

<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8"import="java.sql.*" %>
<%@ page import="java.net.*"%>
<%@ page pageEncoding="UTF-8"%>


   

<%
        //设置输出信息的格式及字符集        

        response.setContentType( "text/xml" );
        response.setCharacterEncoding( "UTF-8" );
        String searchWhat="nihao";
        searchWhat=request.getParameter("search");
        searchWhat = java.net.URLDecoder.decode(searchWhat, "utf-8");
        
         Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
         String  url="jdbc:microsoft:sqlserver://localhost;DatabaseName=xy";
         String  user="sa";
         String  password="a";
         Connection  conn=  DriverManager.getConnection(url,user,password);
         
         Statement  stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); 
         if(!searchWhat.equals(""))
          {
             

                    String searchHot="select userName from yonghu where userName='"+searchWhat+"'";//取出这个文章的地址
                    ResultSet rs_shishi=stmt.executeQuery(searchHot);             
                   // out.print("<responses>");
                    if(rs_shishi.next())
                     {          
                           out.print(searchWhat+"用户已存在！");
                     }
                     else{out.print(searchWhat+"用户可以用！");}
                     
                    // out.print("</responses>");

                    out.close();
        }
        stmt.close();
        conn.close();
 %>