JDBC增(预编译方式)
public static void main(String[] args) throws Exception {
String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
String username="root";
String password="123456";
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection(url, username, password);
String sql="insert into users(id, name, password, email, birthday) values (?,?,?,?,?);";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setInt(1,5);
preparedStatement.setString(2,"坤士南山1 ");
preparedStatement.setString(3,"12314");
preparedStatement.setString(4,"44@qq.com");
preparedStatement.setDate(5,new Date(new java.util.Date().getTime()));
int i = preparedStatement.executeUpdate();
if(i>0){
System.out.println("插入成功");
}
preparedStatement.close();
connection.close();
}
JDBC删(预编译方式)
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
String username="root";
String password="123456";
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection(url, username, password);
String sql="delete from users where id =?;";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1,"4 ");
int i = preparedStatement.executeUpdate();
if(i>0){
System.out.println("执行成功");
}else{
System.out.println("执行失败");
}
preparedStatement.close();
connection.close();
}
JDBC改(预编译方式)
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
String username="root";
String password="123456";
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection(url, username, password);
String sql="update users set name = ?,password = ?,email = ?,birthday = ? where id = ?;";
PreparedStatement preparedStatement = connection.prepareStatement(sql);
preparedStatement.setString(1,"坤士南山 ");
preparedStatement.setString(2,"12314");
preparedStatement.setString(3,"ns@qq.com");
preparedStatement.setDate(4,new Date(new java.util.Date().getTime()));
preparedStatement.setInt(5,4);
int i = preparedStatement.executeUpdate();
if(i>0){
System.out.println("执行成功");
}else{
System.out.println("执行失败");
}
preparedStatement.close();
connection.close();
}
JDBC查
public static void main(String[] args) throws ClassNotFoundException, SQLException {
String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";
String username="root";
String password="123456";
Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection(url, username, password);
Statement statement = connection.createStatement();
String sql="select * from users";
ResultSet rs = statement.executeQuery(sql);
while (rs.next()){
System.out.println("id"+rs.getObject("id"));
System.out.println("name"+rs.getObject("name"));
System.out.println("password"+rs.getObject("password"));
System.out.println("email"+rs.getObject("email"));
System.out.println("birthday"+rs.getObject("birthday"));
}
rs.close();
statement.close();
connection.close();
}