编写JDBC程序使用PreparedStatement向数据库插入一条数据

//编写JDBC程序使用PreparedStatement
//向数据库插入一条数据
package qqq;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Date;

public class Example02 {
    public static void main(String args[]) {
        PreparedStatement preStmt=null;
        Connection conn = null;
        try {
            //1.注册数据库驱动
            /* Driver driver = new Driver();
            DriverManager.registerDriver(driver);*/
            Class.forName("com.mysql.jdbc.Driver");
            //2、获取连接对象
            String url = "jdbc:mysql://localhost:3306/jdbc";
            String username = "root";
            String password = "root";
            conn = DriverManager.getConnection(url, username, password);
            //3 、向数据库发送查询语句获取sql语句的对象
            String sql = "insert into users values (?,?,?,?,?)";//这里面的？称为占位符
            preStmt =conn.prepareStatement(sql);
            //4、执行sql前要为占位符赋值
            preStmt.setInt(1,11);//括号里面的第一个数字代表数据库里面的位置
            preStmt.setString(2,"ss");
            preStmt.setString(3,"123");
            preStmt.setString(4,"234@qq.com");
            java.sql.Date  date=new java.sql.Date(new Date().getTime());//需要导入import java.util.Date;
            preStmt.setDate(5,date);//数据库里面点的数据库类型是java.sql.date
            //5、执行看是否插入成功
            int row=preStmt.executeUpdate();
            if(row==1){
                System.out.println("插入成功");
            }else{
                System.out.println("插入成功");
            }
        } catch (Exception e) {
            throw new RuntimeException(e);
        } finally {
            //关闭连接
            if (preStmt != null) {
                try {
                    preStmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                preStmt=null;
            }

            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
                conn=null;
            }

        }
    }
}
运行结果

数据库插入之前

数据库插入之后

 

补充：