添加
PreparedStatement prep =
(PreparedStatement) conn.prepareStatement(
"insert into t_emp(name,salary,age) " +
"values(?,?,?)");
prep.setString(1, name);
prep.setDouble(2, Double.parseDouble(salary));
prep.setInt(3, Integer.parseInt(age));
prep.executeUpdate();
查询
Statement stat = conn.createStatement();
ResultSet rst = stat.executeQuery("select * from t_emp");
while (rst.next()){
out.println(rst.getString("name")+" "+rst.getDouble("salary")+" "+
rst.getInt("age"));
}
PreparedStatement prep=
conn.prepareStatement("select * from f_user where username=?");
prep.setString(1,username);
ResultSet rst = prep.executeQuery();
if(rst.next()){
user = new User();
user.setId(rst.getInt("id"));
user.setUsername(rst.getString("username"));
user.setAsk(rst.getString("ask"));
}
删除
conn = DBUtil.getConnection();
PreparedStatement prep =
conn.prepareStatement("delete from " +
"t_emp where id=?");
prep.setInt(1, id);
prep.executeUpdate();
修改
先要 得到 一个 修改界面的表单 然后 进行修改
load ----------------->>>> modify
PreparedStatement prep =
conn.prepareStatement("update t_emp " +
"set name=?,salary=?,age=? where id=?");
prep.setString(1, name);
prep.setDouble(2, salary);
prep.setInt(3, age);
prep.setInt(4, id);
prep.executeUpdate();
PreparedStatement prep =
(PreparedStatement) conn.prepareStatement(
"insert into t_emp(name,salary,age) " +
"values(?,?,?)");
prep.setString(1, name);
prep.setDouble(2, Double.parseDouble(salary));
prep.setInt(3, Integer.parseInt(age));
prep.executeUpdate();
查询
Statement stat = conn.createStatement();
ResultSet rst = stat.executeQuery("select * from t_emp");
while (rst.next()){
out.println(rst.getString("name")+" "+rst.getDouble("salary")+" "+
rst.getInt("age"));
}
PreparedStatement prep=
conn.prepareStatement("select * from f_user where username=?");
prep.setString(1,username);
ResultSet rst = prep.executeQuery();
if(rst.next()){
user = new User();
user.setId(rst.getInt("id"));
user.setUsername(rst.getString("username"));
user.setAsk(rst.getString("ask"));
}
删除
conn = DBUtil.getConnection();
PreparedStatement prep =
conn.prepareStatement("delete from " +
"t_emp where id=?");
prep.setInt(1, id);
prep.executeUpdate();
修改
先要 得到 一个 修改界面的表单 然后 进行修改
load ----------------->>>> modify
PreparedStatement prep =
conn.prepareStatement("update t_emp " +
"set name=?,salary=?,age=? where id=?");
prep.setString(1, name);
prep.setDouble(2, salary);
prep.setInt(3, age);
prep.setInt(4, id);
prep.executeUpdate();