src/com/dgy/dao/TjDao.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 com.dgy.bean.StudentBean;
import com.dgy.bean.TjBean;
import com.dgy.util.DBManager;


public class TjDao {
	/**向体检表中插入数据
	 * 
	 * @param args
	 */
	public static void insertTj(int sid,String blood_pressure,String heart,String lung,String liver,String chest){
		Connection con = DBManager.getConn();
		PreparedStatement pstmt = null;
		String sql = "insert into tj (sid,blood_pressure,heart,lung,liver,chest)values(?,?,?,?,?,?)";
		try {
			pstmt = con.prepareStatement(sql);
			pstmt.setInt(1, sid);
			pstmt.setString(2, blood_pressure);
			pstmt.setString(3, heart);
			pstmt.setString(4, lung);
			pstmt.setString(5, liver);
			pstmt.setString(6, chest);
			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();
			}
		}
		
	}
	
	/**查询所有体检结果
	 * 
	 * @param args
	 */
	public static ArrayList<TjBean> viewAllTjResult(){
		Connection con = DBManager.getConn();
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String sql = "select * from tj";
		ArrayList<TjBean> tj = new ArrayList<TjBean>();
		try {
			pstmt = con.prepareStatement(sql);
			rs = pstmt.executeQuery();
			while(rs.next()){