老师检查一下

问题描述：1.修改的sql语句能一次改两个属性吗，例如，但是报错了，老师能示范一下吗

String sql = "update news set (title =?,content=?) where id=?";

问题描述：2.输入id后会单独显示一行你输入的id的新闻，不会单独显示出来

相关截图：

相关代码：

package chapter10_2.command;

import java.util.Scanner;

public class newsTest {
    public static void main(String[] args) {
        boolean flag = true;
        Scanner scanner = new Scanner(System.in);
        Command command = null;
        do {
            System.out.println("欢迎来到新闻管理系统");
            System.out.println("=======================");
            System.out.println("           1  添加新闻                 ");
            System.out.println("           2  查看新闻                 ");
            System.out.println("           3  编辑新闻                 ");
            System.out.println("           4  删除新闻                 ");
            System.out.println("           5  退出系统                 ");
            System.out.println("请输入1-5之间的数字进行操作");
            int sc = scanner.nextInt();
            if (sc > 5 || sc < 1) {
                System.out.println("输入错误，请用户重新输入：");
            } else {
                switch (sc) {
                    case 1:
                        command = new InsertNewsCommand();
                        command.execute();
                        break;
                    case 2:
                        command = new QueryNewsCommand();
                        command.execute();
                        break;
                    case 3:
                        command = new EditNewsCommand();
                        command.execute();
                        break;
                    case 4:
                        command = new DeleteNewsCommand();
                        command.execute();
                        break;
                    case 5:
                        System.out.println("退出成功！");
                        flag = false;
                        //System.exit(0);
                        break;
                }
            }
        } while (flag);
    }
}

package chapter10_2.command;

import chapter10_2.enity.news;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import javax.sql.DataSource;
import java.io.FileInputStream;
import java.io.UnsupportedEncodingException;
import java.net.URLDecoder;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;
import java.util.Properties;
import java.util.Scanner;

public class EditNewsCommand implements Command{
    public void query(){
        Connection conn = null;

        Properties properties = new Properties();
        String propertyFlie = EditNewsCommand.class.getResource("/druid-config.properties").getPath();
            try {
                propertyFlie = URLDecoder.decode(propertyFlie,"UTF-8");
                properties.load(new FileInputStream(propertyFlie));
                DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);

                QueryRunner qr = new QueryRunner(dataSource);
                List<news> list = qr.query("select * from news ",
                        new BeanListHandler<>(news.class));
                for(news n : list){
                    System.out.println(n.toString());
                }
            } catch (Exception e) {
                e.printStackTrace();
            }

    }


    @Override
    public void execute() {
        Connection conn = null;
        query();
        Scanner scanner = new Scanner(System.in);
        System.out.println("请输入要修改的新闻id");
        Integer id  = scanner.nextInt();
        System.out.println("请输入要修改的新闻标题");
        String title = scanner.next();
        System.out.println("请输入要修改的新闻内容");
        String content = scanner.next();


        Properties properties = new Properties();
        String propertyFlie = EditNewsCommand.class.getResource("/druid-config.properties").getPath();
        try {
            propertyFlie = URLDecoder.decode(propertyFlie,"UTF-8");
            properties.load(new FileInputStream(propertyFlie));

            DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);
            conn = dataSource.getConnection();
            conn.setAutoCommit(false);

           String sql = "update news set title =? where id=?";
           String sql1 = "update news set content=? where id = ?";
            QueryRunner qr = new QueryRunner();
            qr.update(conn,sql,new Object[]{title,id});
            qr.update(conn,sql1,new Object[]{content,id});
            conn.commit();
            System.out.println("修改成功！");
        } catch (Exception e) {
            e.printStackTrace();
            try {
                if(conn != null && !conn.isClosed()){
                    conn.rollback();
                }
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }

    }
}