使用DbUtils访问数据库

 

    /**

     * 删除无主键表数据 GongChengKehuxinxi1

     * @param id

     */

    publicstaticvoid deleteGongChengKehuxinxi1(Integer id) {

       Connection conn = null;

       String url = "jdbc:sqlserver://localhost:1433;databaseName=CSSTOA";

       String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

       String user = "sa";

       String password = "123";

       DbUtils.loadDriver(driver);

       try {

           conn = DriverManager.getConnection(url, user,password);

           Statement st = conn.createStatement();

           st.execute("deleteGongCheng_kehuxinxi_1 where Id = "+id);

       } catch (SQLException e) {

           e.printStackTrace();

       } finally {

           DbUtils.closeQuietly(conn);

       }

    }

 

 

    publicstaticboolean saveScGongChengKehuxinxi1() {

       Connection conn = null;

       String url = "jdbc:sqlserver://localhost:1433;databaseName=CSSTOA";

       String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

       String user = "sa";

       String password = "123";

       DbUtils.loadDriver(driver);

       try {

           conn = DriverManager.getConnection(url, user,password);

           QueryRunner qr = new QueryRunner(true);

           //qr.execute()  亦可 

           qr.update(conn, "insertinto GongCheng_kehuxinxi_1(id,ProjectId,UserId,AppendId,kehumingcheng1_id,kehumingcheng1)values (10001,10000,10000,10000,01,'asdf')");

       } catch (SQLException e) {

           e.printStackTrace();

       } finally {

           DbUtils.closeQuietly(conn);

       }

       returntrue;

    }

 

 

 

           results = (List) qr.query(conn,"select id,projectId,kehumingcheng1 from GongCheng_kehuxinxi_1where projectId=3574", newBeanListHandler(

                                GongChengKehuxinxi1.class));