src/com/dgy/dao/CarDao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.dgy.dao;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import com.dgy.bean.CarBean;
import com.dgy.util.DBManager;

public class CarDao {

	/**
	 * @param args
	 */
	public static void addCar(String cnum,String ctype,String cdate,int cprice){
		Connection con =  DBManager.getConn();
		PreparedStatement pstmt = null;
		String sql = "insert into car (cnum,ctype,cdate,cprice,cstate) values(?,?,?,?,'未分配')";
		try {
			pstmt = con.prepareStatement(sql);
			pstmt.setString(1, cnum);
			pstmt.setString(2, ctype);
			pstmt.setString(3, cdate);
			pstmt.setInt(4, cprice);
			
			pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				pstmt.close();
				con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
	public static void updateCarType(int cid){
		Connection con =  DBManager.getConn();
		PreparedStatement pstmt = null;
		String sql = "update car set cstate='已分配' where cid=?";
		try {
			pstmt = con.prepareStatement(sql);
			pstmt.setInt(1, cid);
			pstmt.executeUpdate();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			try {
				pstmt.close();
				con.close();
			} catch (SQLException e) {