methodsachieve.java

需要平台：Myeclips+Mysql或Myeclips+SQL Server 2

package com.control;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.JOptionPane;

import com.model.DBConn;
import com.view.GUIinit;

public class MethodsAchieve implements InterfaceStudent {
	private Connection conn;
	private Statement sql;
	private ResultSet rs;
	public MethodsAchieve(Connection con) {
		// TODO Auto-generated constructor stub
		this.conn=con;
		//conn=gui.getConn();
	}
	public void AddStudent() {
		String stu_name=GUIinit.getName_tf();
		String stu_sex=GUIinit.getSex_tf();
		Float stu_grade;
		stu_grade=Float.valueOf(GUIinit.getGrade_tf1());
		
		try {
		sql=conn.createStatement();
		
		rs = sql.executeQuery("select MAX(student_id) from student");
		rs.next();
		int stu_id = rs.getInt(1) + 1;
		sql.execute("insert into student values(" + stu_id + ",'"+ stu_name + "','" + stu_sex + "','" + GUIinit.getBirthday_tf() + "'," + stu_grade+ ")");
		rs=sql.executeQuery("select * from student");
		while(rs.next()){
			int id=rs.getInt(1);
			String name=rs.getString(2);
			String sex=rs.getString(3);
			String birthday=rs.getString(4);
			float grade=rs.getFloat(5);
			
			Vector vl=new Vector();
			vl.add(id);
			vl.add(name);
			vl.add(sex);
			vl.add(birthday);
			vl.add(grade);
			GUIinit.getDm().addRow(vl);
			
		}
		} catch (SQLException e1) {
		e1.printStackTrace();
		}
		
	}

	public void DeleteStudent() {
		String sqll;
		sqll=rb_delete();
		if(sqll!=null){
			try {
				sql=conn.createStatement();
				sql.execute(sqll);
				rs=sql.executeQuery("select * from student");
				while(rs.next()){
					int id=rs.getInt(1);
					String name=rs.getString(2);
					String sex=rs.getString(3);
					String birthday=rs.getString(4);
					float grade=rs.getFloat(5);
						
					Vector vl=new Vector();
					vl.add(id);
					vl.add(name);
					vl.add(sex);
					vl.add(birthday);
					vl.add(grade);
					GUIinit.getDm().addRow(vl);
				}
				
			}catch (SQLException e1) {
				e1.printStackTrace();
			}
		}
		
		
	}

	public void QueryStudent() {
		String sqll;
		sqll=chb_query();
		if(sqll!=null){
			StringBuffer sbsql=new StringBuffer(sqll);
			sqll=sbsql.delete(sqll.length()-5, sqll.length()-1).toString();
			System.out.println(sqll);
			try {
				sql=conn.createStatement();
				rs=sql.executeQuery(sqll);
				if(rs==null){
					JOptionPane.showMessageDialog(null, "对不起，没有您要查找的记录！");
					GUIinit.getId_tff().setFocusable(true);
				}
				else{
					while(rs.next()){
						Integer id=rs.getInt(1);
						String name=rs.getString(2);
						String sex=rs.getString(3);
						String birthday=rs.getString(4);
						float grade=rs.getFloat(5);
						
						Vector vl=new Vector();
						vl.add(id);
						vl.add(name);
						vl.add(sex);
						vl.add(birthday);
						vl.add(grade);
						GUIinit.getDm().addRow(vl);
						
					}
				}
				} catch (SQLException e1) {
				e1.printStackTrace();
				}
		}
		else{
			try {
			sql=conn.createStatement();
			rs=sql.executeQuery("select * from student");
			while(rs.next()){
				Integer id=rs.getInt(1);
				String name=rs.getString(2);
				String sex=rs.getString(3);
				String birthday=rs.getString(4);
				float grade=rs.getFloat(5);
				
				Vector vl=new Vector();
				vl.add(id);
				vl.add(name);
				vl.add(sex);
				vl.add(birthday);
				vl.add(grade);
				GUIinit.getDm().addRow(vl);
				
			}
			} catch (SQLException e1) {
			e1.printStackTrace();
			}
		}
	}

	public void ReworkStudent() {
		// TODO Auto-generated method stub
		try {
			sql=conn.createStatement();
			Integer stu_id;
			stu_id=Integer.valueOf(GUIinit.getId_tf());
			//String stu_name=name_tf.getText();
			sql.execute("update student set student_name='"+GUIinit.getName_tf()+"', student_sex='"+GUIinit.getSex_tf()+"', student_birthday='"+GUIinit.getBirthday_tf()+"', student_grade='"+GUIinit.getGrade_tf1()+"' where student_id='"+stu_id+"'");
			rs=sql.executeQuery("select * from student");
			while(rs.next()){
				int id=rs.getInt(1);
				String name=rs.getString(2);
				String sex=rs.getString(3);
				String birthday=rs.getString(4);
				float grade=rs.getFloat(5);
				Vector vl=new Vector();
				vl.add(id);
				vl.add(name);
				vl.add(sex);
				vl.add(birthday);
				vl.add(grade);
				GUIinit.getDm().addRow(vl);
				
			}
			
		} catch (SQLException e1) {
			
			e1.printStackTrace();
		}
		
	}
	public String rb_delete(){
		String sqll="delete from student where ";
		String sql_id="student_id=";
		String sql_name="student_name=";
		String sql_sex="student_sex=";
		
		if(GUIinit.getId_rb().isSelected()||GUIinit.getName_rb().isSelected()||GUIinit.getSex_rb().isSelected()){
			if(GUIinit.getId_rb().isSelected()) 
				sqll+=sql_id+GUIinit.getId_tf();
			else{
				if(GUIinit.getName_rb().isSelected())
					sqll+=sql_name+"'"+GUIinit.getName_tf()+"'";
				else{
					if(GUIinit.getSex_rb().isSelected())
						sqll+=sql_sex+"'"+GUIinit.getSex_tf()+"'";
				}
			}
			return sqll;
		}
		else{
			return null;
		}
			
		
		
	}
	public String chb_query(){
		String sqll="select * from student where ";
		String sql_id="student_id=";
		String sql_name="student_name=";
		String sql_sex="student_sex=";
		String sql_grade1="student_grade";
		String sql_and=" and ";
		if(GUIinit.getId_cb().isSelected()||GUIinit.getName_cb().isSelected()||GUIinit.getSex_cb().isSelected()||GUIinit.getGrade_cb().isSelected()){  
			if(GUIinit.getId_cb().isSelected()) 
				sqll+=sql_id+GUIinit.getId_tf()+sql_and;
			if(GUIinit.getName_cb().isSelected())
				sqll+=sql_name+"'"+GUIinit.getName_tf()+"'"+sql_and;
			if(GUIinit.getSex_cb().isSelected())
				sqll+=sql_sex+"'"+GUIinit.getSex_tf()+"'"+sql_and;
			if(GUIinit.getGrade_cb().isSelected())
				sqll+=sql_grade1+">="+GUIinit.getGrade_tf1()+"&&"+sql_grade1+"<="+GUIinit.getGrade_tf2()+sql_and;
			return sqll;
		}
		else{
			return null;
		}
			
		
		
	}

}