tinputbean.java

学生档案管理系统 eclipse开发 数据库用的是SQL Sever 详细见里面的说明

package Beans;

import java.sql.*;


public class TinputBean implements java.io.Serializable {
	//private String name;
	int course,id,grade; 
	public ResultSet getrs(String id)
	{
		String sql="Select Course_ID,Coures_Name "
			+"from Tb_Course_Info where Teacher_ID="+
			id;
		dbAccess.Conn Conner=new dbAccess.Conn();
		ResultSet rs=null;
		Conner.connectdb(sql);
		rs=Conner.getrs();
		return(rs);

	}
	public int getCourse() {
		return course;
	}
	public void setCourse(int course) {
		this.course = course;
	}
	public int getGrade() {
		return grade;
	}
	public void setGrade(int grade) {
		this.grade = grade;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public boolean insert()
	{
		String sql="insert into Tb_CourseSelecInfo values("+String.valueOf(id)+","+String.valueOf(course)+","+String.valueOf(grade)+")";
		ResultSet rs=null;
		dbAccess.Conn Conner=new dbAccess.Conn();
		return(Conner.connectdb(sql));
	}

}