批处理
Statement addBatch(sql); //添加SQL命令
executeBatch()方法:执行批处理命令
clearBatch()方法:清楚批处理命令
JDBC获取主键和调用存储过程
st=conn.prepareStatement(sql);
st.excuteUpdate();
rs=st.getGenerateKeys();
if(rs.next()){
System.out.println(rs.getInt(i));
}
//存储过程
//1.得到CallableStatement,并调用存储过程:
CallableStatement cStmt=conn.prepareCall("{call demoSp(?,?)}");
//2.设置参数,注册返回值,得到输出
cStmt.setString(1,"abcdefg");
cStmt.registerOutParameter(2,Types.VARCHAR);
cStmt.execute();
System.out.println(cStmt.getString(2));
MVC开发模式
JavaBean–>Model
Jsp–>View
Sevlet–>Controller
Web层
业务逻辑层
数据访问层(dao层)
分包:
domain
dao
dao.impl
service
service.impl
web.controller
web.listener
web.filter
utils
Junit.test
WEB-INF/jsp 保存网站所有jsp