studentdao.java

来自「C语言小型分析器实验报告1） 待分析的简化C语言的词法说明； 2） 单词符号的」· Java 代码 · 共 66 行

package dao;

import java.sql.SQLException;

public class StudentDao {
	private String number;
	private String name;
	private String speciality;
	private String grade;
	private BasicDao dao;
	
	public StudentDao(String number, String name, String speciality, String grade){
		this.number = number;
		this.name = name;
		this.speciality = speciality;
		this.grade = grade;
		dao = new BasicDao();
	}
	
	public int insertStudent(){
		String sql = "insert into t_basic_info(number,name,speciality,grade) values ('" + number + "','" + name + "','" + speciality + "','" + grade +"')";
		System.out.println(sql);
		int row = 0;
		try {
			row = dao.executeString(sql);
			return row;
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return row;
	}

	public String getNumber() {
		return number;
	}

	public void setNumber(String number) {
		this.number = number;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getSpeciality() {
		return speciality;
	}

	public void setSpeciality(String speciality) {
		this.speciality = speciality;
	}

	public String getGrade() {
		return grade;
	}

	public void setGrade(String grade) {
		this.grade = grade;
	}
	
}