通过ider在数据库中添加数据

最新推荐文章于 2024-07-13 18:10:19 发布

Zhrlt

最新推荐文章于 2024-07-13 18:10:19 发布

阅读量375

点赞数

文章标签：数据库 java servlet

本文链接：https://blog.csdn.net/Zhrlt/article/details/127822138

版权

package work.work01.test01;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.text.SimpleDateFormat;
import java.util.Date;

public class OnlineQA {
    public static void main(String[] args) {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection("jdbc:mysql:///myschool", "root", "root");
            String sql="insert into questions()value(null,?,?,?,?)";
            PreparedStatement ps = conn.prepareStatement(sql);
            ps.setString(1,"化学");
            ps.setString(2,"不会实验");
            ps.setString(3,"二次");
            Date date = new Date();
            SimpleDateFormat sbf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            String da = sbf.format(date);
            ps.setString(4,da);
            int count = ps.executeUpdate();
            System.out.println(count>0?"成功":"失败");
            ps.close();
            conn.close();
        } catch (SQLException | ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
}