使用Java操作数据库的步骤

1.加载驱动

     Class.forName("com.mysql.jdbc.Driver");

---

2.获取数据库连接

     public java.sql.Connection 

getConnection(){

        if(conn ==null){

           try {

              conn=DriverManager.getConnection( "jdbc:mysql://localhost:3306/数据库名"            

,"root","密码" );

          } catch (SQLException e) {

              e.printStackTrace();

          }

       }

        return conn ;

   }

---

3.数据库操作

     添加：

          public int addBookStoreBean(BookStoreBean bsb){

       java.sql.PreparedStatement pstmt=null;

        int result=0;

        try {

          pstmt= conn.prepareStatement("insert into t_bookStore values(?,?,?,?,?)");

          pstmt.setInt(1, bsb.getId());

          pstmt.setString(2, bsb.getName());

          pstmt.setString(3, bsb.getPrice());

          pstmt.setString(4,bsb.getPublish());

          pstmt.setString(5,bsb.getOther());

          result=pstmt.executeUpdate();

          System. out.println("添加信息成功!" );

       } catch (SQLException e) {

          e.printStackTrace();

       } finally{

           try {

              pstmt.close();

          } catch (SQLException e) {

              e.printStackTrace();

          }

       }

        return result;

   }

     删除：

          public void delBookStoreBean(int id){

       java.sql.PreparedStatement pstmt=null;

        try {

          pstmt= conn.prepareStatement("delete from t_bookStore where id=?");

          pstmt.setInt(1, id);

          pstmt.execute();

          System. out.println("删除成功!" );

       } catch (SQLException e) {

          e.printStackTrace();

       } finally{

           try {

              pstmt.close();

          } catch (SQLException e) {

              e.printStackTrace();

          }

       }

   }  

     更新：

          public void updateBookStoreBean(BookStoreBean bsb){

       java.sql.PreparedStatement pstmt=null;

        try {

          pstmt= conn.prepareStatement("update t_bookStore set name=? ,price=?,publish=?,other=? where id=?");

          pstmt.setInt(1, bsb.getId());

.setString(2, bsb.getName());

          pstmt.setString(3, bsb.getPrice());

          pstmt.setString(4,bsb.getPublish());

          pstmt.setString(5,bsb.getOther());

          pstmt.executeUpdate();

       } catch (SQLException e) {

          e.printStackTrace();

       } finally{

           try {

              pstmt.close();

          } catch (SQLException e) {

              e.printStackTrace();

          }

       }

       

   }

     查询：

          public List<BookStoreBean> query(){

       java.sql.Statement stmt= null;

       java.sql.ResultSet rs= null;

       List<BookStoreBean> result= new ArrayList<BookStoreBean>();

        try {

          stmt= conn.createStatement();

          rs=stmt.executeQuery( "select * from t_bookStore");

           while(rs.next()){

              BookStoreBean bsb= new BookStoreBean();

              bsb.setId(rs.getInt( "id"));

             bsb.setName(rs.getString( "name"));

             bsb.setPrice(rs.getString( "price"));

             bsb.setPublish(rs.getString( "publish"));

             bsb.setOther(rs.getString( "other"));

              result.add(bsb);

          }

       } catch (SQLException e) {

          e.printStackTrace();

       } finally{

           try {

              rs.close();

          } catch (SQLException e) {

              e.printStackTrace();

          }

           try {

              stmt.close();

          } catch (SQLException e) {

              e.printStackTrace();

          }

       }

        return result;

   }

---

   

4.关闭数据库

     public void closeConnection(){

        if(conn ==null){

           try {

               conn.close();

          } catch (SQLException e) {

              e.printStackTrace();

          }

       }

   }