智能家居调研

数据库,数据库的增删查改操作,增删查改,数据库的操作 Ôö?Ó?º?º?º 1?? Ê?ÓÃ?ý?Ì?æ?? con.setAutoCommit(false); CallableStatement cs = con.prepareCall("{ call save_user(?,?)}"); cs.setString(1, name); cs.setString(2, password); cs.execute(); 2??ÊÇÓú?Êý?æ?? Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select max(id) from java_user"); rs.next(); int maxId = rs.getInt(1); 3?? PreparedStatement ps = con.prepareStatement("insert into java_user values(?,?,?)"); ps.setInt(1, ++maxId); ps.setString(2, name); ps.setString(3, password); ps.execute(); 4?? int hang = st.executeUpdate("insert into java_user values(" + (++maxId) + ",'" + name + "','" + password + "')"); if (hang == 1) { result = true; } ?éÕÒ?º?º?º 1?? Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select * from java_user where name like '" + name + "%'"); 2?? CallableStatement cs = con.prepareCall("{call my_pack.getUsers(?,?)}"); cs.setString(1, name); cs.registerOutParameter(2, OracleTypes.CURSOR); cs.execute(); ResultSet rs = (ResultSet) cs.getObject(2); ÐÞ?Ä?º?º?º 1?? con.setAutoCommit(false); CallableStatement cs = con.prepareCall("{ call update_user(?,?)}"); cs.setString(1, name); cs.setString(2, password); cs.execute(); con.commit(); 2?? con.setAutoCommit(false); PreparedStatement ps = con.prepareStatement("update java_user set password=? where name=?"); ps.setString(1, password); ps.setString(2, name); ps.execute(); con.commit(); 3?? con.setAutoCommit(false); Statement st = con.createStatement(); st.executeUpdate("update java_user set password='" + password + "' where name='" + name + "'"); con.commit(); ??Ìõ?þ?éÕÒ?º?º?º 1?? CallableStatement cs = con.prepareCall("{? = call check_javauser(?,?)}"); cs.registerOutParameter(1, Types.VARCHAR); cs.setString(2, name); cs.setString(3, password); cs.execute(); String s = cs.getString(1); if (s.equals("ok")) { result = true; } 2?? CallableStatement cs = con.prepareCall("{call check_user(?,?,?)}"); cs.setString(1, name); cs.setString(2, password); cs.registerOutParameter(3, Types.VARCHAR); cs.execute(); String s = cs.getString(3); if (s.equals("ok")) { result = true; } 3?? PreparedStatement ps = con.prepareStatement("select 1 from java_user where name=? and password=?"); ps.setString(1, name); ps.setString(2, password); ResultSet rs = ps.executeQuery(); if (rs.next()) { result = true; } 4?? Statement st = con.createStatement(); ResultSet rs = st.executeQuery("select 1 from java_user where name='" + name + "' and password='" + password + "'"); if (rs.next()) { result = true; }