java连接SQL server 2005(jdbc)(已测试成功)

    技术2025-11-14  4

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

           String user="sa";          String pwd="123";          //JDBC连接方式    String url="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=name ";    //注册驱动           //DriverManager.registerDriver (new com.microsoft.sqlserver.jdbc.SQLServerDriver());                  //获得一个连接    conn = DriverManager.getConnection (url,user,pwd);    //JOptionPane.showMessageDialog (null, "连接成功");       // 设置自动提交为false   conn.setAutoCommit (false);   //建立高级载体   ste = conn.createStatement (ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);     }     catch (Exception ex) {      JOptionPane.showMessageDialog (null, "数据库连接失败...", "错误", JOptionPane.ERROR_MESSAGE);      ex.printStackTrace();     } }

    最新回复(0)