servlet 连接 mssql

 //连接MSSQL 2008
 protected void doconn(){
  try {
   Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
   conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=basename","sa","psw");
   
  } catch (SQLException | ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } 
 }

//连接MSSQL 2000

protected void doconn(){
  try {
   Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
   conn=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=basename","sa","psw");
  
  } catch (SQLException | ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
}

/*********************************************************/

  //查询数据表
 protected ResultSet getResult(){
  doconn();
  String sql1="select * from userlist"; 

  try {
   Statement stm=conn.createStatement(); 
   ResultSet rs=stm.executeQuery(sql1); 
   return rs;
  } catch (SQLException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
  return null;    
    
 }

 

/*******************************************************/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
  request.setCharacterEncoding("utf-8");
  //String name = request.getParameter("name");
  response.setContentType("text/html;charset=utf-8");
  PrintWriter pw = response.getWriter();
  ResultSet rs=getResult();
  if(rs!=null){
   try {
    while (rs.next()) {
     pw.write(rs.getString("name"));
     
    }
    rs.close();
    conn.close();
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
   
  }
  /*
  if(name.equals("admin")){   
  pw.write("hello "+name+",欢迎登录本系统！"+conn);
  }else {
  pw.write("你好 "+name+",你不是本系统的合法用户！"); 
  }
  pw.close();
  */
 }