printmodifyvalue.java

来自「学生学籍管理系统sql 学生学籍管理系统sql」· Java 代码 · 共 75 行

package com.record.publicCode;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import com.record.connectionDataBase.ConnectionDataBase;

public class PrintModifyValue {
	Connection conn;
	ResultSet rs;
	public String getModifyValue(String action,int id,String fieldName,String dataBaseName){
		String returnValue="";
		ConnectionDataBase connectionDataBase=new ConnectionDataBase();
		//System.out.print(action.equals("modify"));
		conn=connectionDataBase.getConn();
		if(action.equals("modify") || action.equals("detail")){
			String sql="select * from "+dataBaseName+" where id="+id;
			try {
				rs=conn.createStatement().executeQuery(sql);
				if(rs.next()){
					returnValue=rs.getString(fieldName);
				}
				
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return returnValue;
	}
	
	public String getModifyChargeValue(String action,int s_id,String c_term,String fieldName,String dataBaseName){
		String returnValue="";
		ConnectionDataBase connectionDataBase=new ConnectionDataBase();
		conn=connectionDataBase.getConn();
		//System.out.print(action.equals("modify"));
		if(action.equals("modify")){
			String sql="select * from "+dataBaseName+" where s_id="+s_id+" and c_term='"+c_term.trim()+"'";
			//System.out.print(sql);
			try {
				rs=conn.createStatement().executeQuery(sql);
				if(rs.next()){
					returnValue=rs.getString(fieldName);
				}
				
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return returnValue;
	}
	
	public String getModifyDetailValue(String action,int s_id,String c_term,String d_type,String fieldName,String dataBaseName){
		String returnValue="";
		ConnectionDataBase connectionDataBase=new ConnectionDataBase();
		conn=connectionDataBase.getConn();
		if(action.equals("modify")){
			String sql="select * from "+dataBaseName+" where s_id="+s_id+" and d_type='"+d_type+"' and c_term='"+c_term.trim()+"'";
			//System.out.print(sql);
			try {
				rs=conn.createStatement().executeQuery(sql);
				if(rs.next()){
					returnValue=rs.getString(fieldName);
				}
				
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
		return returnValue;
	}
	
}