NoSQL如何实现数据的增删改查？

Question

NoSQL如何实现数据的增删改查？

Answer 1

package basic;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class JDBC {public void findAll() {try {// 获得数据库驱动//由于长时间不写，驱动名和URL都忘记了，不知道对不对，你应该知道的，自己改一下的哈String url = "jdbc:oracle:thin:@localhost:1521:XE";String userName = "system";String password = "system";Class.forName("oracle.jdbc.driver.OracleDriver");// 创建连接Connection conn = DriverManager.getConnection(url, userName,password);// 新建发送sql语句的对象Statement st = conn.createStatement();// 执行sqlString sql = "select * from users";ResultSet rs = st.executeQuery(sql);// 处理结果while(rs.next()){//这个地方就是给你的封装类属性赋值System.out.println("UserName："+rs.getString(0));}// 关闭连接rs.close();st.close();conn.close();} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}public void delete(){try {//步骤还是那六个步骤，前边的两步是一样的String url = "jdbc:oracle:thin:@localhost:1521:XE";String userName = "system";String password = "system";Class.forName("oracle.jdbc.driver.OracleDriver");Connection conn = DriverManager.getConnection(url,userName,password);//这里的发送sql语句的对象是PreparedStatement,成为预处理sql对象，因为按条件删除是需要不定值的String sql = "delete from users where id = ?";PreparedStatement ps = conn.prepareStatement(sql);ps.setInt(0, 1);int row = ps.executeUpdate();if(row!=0){System.out.println("删除成功！");}// 关闭连接rs.close();st.close();conn.close();} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}