WEB应用中数据库操作.pptVIP

创建 增加对应SQL的INSERT，返回增加成功的行（记录）数 conn = getConnection();//获取数据库连接 Statement st = conn.createStatement(); String sql=“insert into user(name, age,regist_date )” + “values(‘name’, 10, now())”; int i = st.executeUpdate(sql); //i为插入的记录数 读 取 读取（查询）对应SQL的SELECT，返回查询结果 conn = getConnection(); Statement st = conn.createStatement(); String sql = select id, name, age,regist_date from user; ResultSet rs = st.executeQuery(sql); while (rs.next()) { System.out.print(rs.getInt(id) + \t\t ); System.out.print(rs.getString(name) + \t\t ); System.out.print(rs.getInt(age) + \t\t ); System.out