java servlet连接sql2005

 

Connection con = null;

   Statement st =null;

   ResultSet rs =null;

   

     try{

     res.setContentType("text/html;charset=gbk");

    PrintWriter pw = res.getWriter();    

    try{

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

    con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:2258;DatabaseName=jtj","sa","123456");

    }catch(Exception e){

    e.printStackTrace();

    }

  st = con.createStatement();

    rs = st.executeQuery("select * from tb");

    if (rs != null){

    while (rs.next()){

    pw.println(rs.getString("title")+"<br>");

    }

    }else{

    pw.println("数据为空");

    }

    HttpSession hs = req.getSession(false);

    if (hs!=null){

    String session = (String)hs.getAttribute("uname");

    pw.println(session);

    }else{

    res.sendRedirect("login");

    }

     }catch(Exception e){

     e.printStackTrace();

     }finally{

     try{

    if (rs!=null){rs.close();}

    if (st!=null){st.close();}

    if (con!=null){con.close();}

     }catch(Exception e){

     }

 

     }

Microsoft SQL Server 2005 JDBC 驱动程序

http://www.microsoft.com/downloads/details.aspx?FamilyID=E22BC83B-32FF-4474-A44A-22B6AE2C4E17&displaylang=zh-cn