tip:以下是正文部分
一、连接数据库
Class.forName("com.mysql.jdbc.Driver");
String db = "jdbc:mysql://localhost:3306/test";
Connection conn = DriverManager.getConnection(db, "root", "");
二、执行查询语句
String sql = "select * from user";
ResultSet rs = st.executeQuery(sql);
执行后返回代表查询结果的ResultSet对象
三、执行增删改语句
String sql = "insert into user11 values(?,?,?,?,?,?)"; //查询指令
PreparedStatement preparedStatement = conn.prepareStatement(sql);
preparedStatement.setInt(1, id);
preparedStatement.setString(2, name);
preparedStatement.setString(3, password);
preparedStatement.setString(4, address);
preparedStatement.setString(5, mobile);
preparedStatement.setDate(6, sqlDate);
int rowsInserted = preparedStatement.executeUpdate();
//rowsInserted表示受影响的行数
preparedStatement.executeUpdate()
tips
java.util.Date date = bartDateFormat.parse(regdate1);
java.sql.Date sqlDate = new java.sql.Date(date.getTime());
//将String转为Java的Date类,再转换为MySQL的Date类并写入数据库