java 连接sqlserver2008 demo

来源：互联网发布：日本微博软件编辑：程序博客网时间：2024/05/08 09:10

这个是servlet中的dopost方法

注意：连接2008数据库与链接2005数据库，jdbc有严重区别 2008需要JDBC4.0

public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {

  String username = request.getParameter("name");
  response.setContentType("text/html");
  PrintWriter out = response.getWriter();
   try {
       try {
     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    } catch (ClassNotFoundException e) {

     e.printStackTrace();
    }
       Connection conn = DriverManager
         .getConnection(
           "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=save_GPS",
           "sa", "admin");
       PreparedStatement pstate = conn.prepareStatement("insert into [JWD](JD,WD,GPS) values(?,?,?)");
       pstate.setString(1,request.getParameter("IMEI"));
       pstate.setString(2,request.getParameter("IMEI"));
       pstate.setString(3,request.getParameter("IMEI"));
       //pstate.setString(2,request.getParameter("pass"));
       int result = pstate.executeUpdate();
       if (result == 1)
       {
       out.println("Success");
       }
      } catch (SQLException e) {

      }
      out.println("<a href='../index.jsp'>back</a>");
    out.flush();
    out.close();