jsp基础教程综合实例项目，jsp教程总结性项目下载。本部分的jsp教程已经告一段落了，以下是一次比较齐全的例子，主要介绍的是网络商城的一些操作，比如购物车操作，用户登陆，数据库的增加删除更新查询，jsp隐含对象的应用，java接口的应用实例、JDBC操作mysql数据库等。
部分java源码实例：
AddCar.java
package com.cn.car;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import com.cn.jdbc.JDBC_Connection;
public class AddCar {
public void addCar(CarsVo carsVo){
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
try {
//调用JDBC_Connection类的getConnection方法连接数据库
conn = JDBC_Connection.getConnection();
//添加数据的sql语句
String sql =
“insert into cars(carnumber,cartype,color,price,rentprice,deposit,isrenting,description) values(?,?,?,?,?,?,?,?)”;
pstm = conn.prepareStatement(sql);
pstm.setString(1, carsVo.getCarnumber());
pstm.setString(2, carsVo.getCartype());
pstm.setString(3, carsVo.getColor());
pstm.setDouble(4, carsVo.getPrice());
pstm.setDouble(5, carsVo.getRentprice());
pstm.setDouble(6, carsVo.getDeposit());
pstm.setInt(7, carsVo.getIsrenting());
pstm.setString(8, carsVo.getDescription());
pstm.executeUpdate();//提交pstm对象
System.out.println(“添加成功！添加的内容如下：”);
System.out.println();
} catch (Exception e) {
e.printStackTrace();
} finally {
JDBC_Connection.free(rs, conn, pstm);
}
}
}
UpdateCustomerServlet.java
package com.cn.customers;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class UpdateCustomerServlet extends HttpServlet {
public void destroy() {
super.destroy(); // Just puts “destroy” string in log
}
public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(“text/html”);
PrintWriter out = response.getWriter();
this.doPost(request, response);
out.flush();
out.close();
}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType(“text/html”);
PrintWriter out = response.getWriter();
UpdateCustomer updateCustomer =new UpdateCustomer();
String identity =request.getParameter(“identity”);//身份证
String custname =request.getParameter(“custname”);//姓名
int sex =Integer.parseInt(request.getParameter(“sex”));//性别
String address =request.getParameter(“address”);//地址
String phone =request.getParameter(“phone”);//电话
String career =request.getParameter(“career”);//职业
String password =request.getParameter(“password”);//密码
customersVo customersVo = new customersVo();
customersVo.setIdentity(identity);
customersVo.setCustname(custname);
customersVo.setSex(sex);
customersVo.setAddress(address);
customersVo.setPhone(phone);
customersVo.setCareer(career);
customersVo.setPassword(password);
updateCustomer.updateCustomer(customersVo);
response.sendRedirect(“ShowAllCustomerServlet”);
out.flush();
out.close();
}
public void init() throws ServletException {
// Put your code here
}
}