1、任务实施内容

1.1  Java连接MySQL数据库netbuy

1.2  Java操作netbuy 数据库数据

2、任务实施步骤

1.1  Java连接MySQL数据库netbuy

String url =

"jdbc:mysql://127.0.0.1:3306/netbuy?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT";

String user= "root";

String passwd= "123456";

try {

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

     Connection conn= DriverManager.getConnection(url,user,passwd);

      if (!conn.isClosed())

          System.out.println("成功连接到数据库！");

       } catch (Exception e) {

               e.printStackTrace();

1.2  Java操作netbuy 数据库数据

 //向type表中增加一条数据

String sql1=

 "insert into payments values('009','个护化妆 ','包括面部护理、身体护理、口腔护理、男性护理等 ')";

Statement statement = conn.createStatement();        

statement.executeUpdate(sql);

//把goods表中商品编号为“D00003”的折扣修改为0.85折

String sql2=

"update goods set g_discount=0.85 where g_id=’D00003’";

Statement statement = conn.createStatement();        

statement.executeUpdate(sql2);

//删除订单表中订单编号为2019092800001的订单信息

String sql3= "delete from orders where  o_id=’2019092800001’";

Statement statement = conn.createStatement();        

statement.executeUpdate(sql3);

//查询江西省的客户编号c_id、客户姓名c_name和身份证号c_cardid

String sql4= "select c_id,c_name,c_cardidfrom customers wherec_address like ‘江西省%’";

Statement statement = conn.createStatement();

ResultSet rs = statement.executeQuery(sql4);

while (rs.next()) {                           

        String cid = rs.getString(1);

String cname= rs.getString(2);

        String ccardid=rs.getString(3);

        System.out.println("\n客户编号：" + cid + "\t客户姓名：" + cname + "\t身份证号："+ ccardid);

}