jdbc for SQLServer2005(jdk1.6) 的查询语句，以及使用事务

1.安装C:\Program Files\Microsoft SQL Server JDBC Driver\sqljdbc_3.0\enu\sqljdbc4.jar

2.设置环境变量：

CLASSPATH =.;C:\Program Files\Microsoft SQL Server JDBC Driver\sqljdbc_3.0\enu\sqljdbc4.jar、

3.（我这么做了，但是这么做有必要没有不知道）

拷贝到

网站目录\ROOT\WEB-INF\lib\sqljdbc4.jar

4.启动tomcat就可以了

 

//读取型语句

ResultSet rs = sql.executeQuery("select * from CompanyBase");
               while(rs.next())
               {
                  out.print(rs.getString("Id"));
                   out.print("     ");
                   out.print(rs.getString("CompanyName"));
                   out.print("     ");
                   out.print("<br/>");
               }

 

//更新型语句
int intAffectedRows = sql.executeUpdate("update CompanyBase set CompanyName = '刘达零售商商' where id = 7661");
out.print(intAffectedRows);

//事务处理

<%
        Connection conn = null;
        Statement sql = null;
        boolean defaultCommit = false;
        String strConn = "jdbc:sqlserver://localhost:1433;databaseName=xltd_b2b;user=sa;password=sa;";
        try
        {
            conn = DriverManager.getConnection(strConn);
            defaultCommit = conn.getAutoCommit();
            conn.setAutoCommit(false);
            sql = conn.createStatement();
            sql.executeUpdate("update CompanyBase set CompanyName='刘达零售商商' where id = 7661");
            sql.executeUpdate("update CompanyBase set CompanyName='刘达零售商商' where id = 7661");
            conn.commit();
        }
        catch(SQLException ex)
        {
            out.print(ex.getMessage());
            conn.rollback();
        }
        finally
        {
            conn.setAutoCommit(defaultCommit);
            if(null != sql)
            {
                sql.close();
            }
            if(null != conn)
            {
                conn.close();
            }
        }
    %>