package?user;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.SQLException;
import?java.sql.Statement;

public?class?AddBean?{
	String?number?=?““?//?學(xué)號
	name?=?““;?//?姓名
int?age?=?0;;
String?sex?=?““;
float?mathScore?physicsScore?chemicalScore?englishScore;
String?addMessage?=?““;



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?int?getAge（）?{
	return?age;
}
public?void?setAge（int?age）?{
	this.age?=?age;
}
public?String?getSex（）?{
	return?sex;
}
public?void?setSex（String?sex）?{
	this.sex?=?sex;
}
public?float?getMathScore（）?{
	return?mathScore;
}
public?void?setMathScore（float?mathScore）?{
	this.mathScore?=?mathScore;
}
public?float?getPhysicsScore（）?{
	return?physicsScore;
}
public?void?setPhysicsScore（float?physicsScore）?{
	this.physicsScore?=?physicsScore;
}
public?float?getChemicalScore（）?{
	return?chemicalScore;
}
public?void?setChemicalScore（float?chemicalScore）?{
	this.chemicalScore?=?chemicalScore;
}
public?float?getEnglishScore（）?{
	return?englishScore;
}
public?void?setEnglishScore（float?englishScore）?{
	this.englishScore?=?englishScore;
}
public?void?setAddMessage（String?addMessage）?{
	this.addMessage?=?addMessage;
}
public?AddBean（）{
try?{
Class.forName（“com.microsoft.sqlserver.jdbc.SQLServerDriver“）
			.newInstance（）;
}?catch?（Exception?e）?{
}
}

public?String?getAddMessage（）?{
String?insertCondition?=?“INSERT?StuTb?VALUES（?‘“?+?number?+?“‘?‘“	+?name?+?“‘“?+age+“‘“+sex+“‘“+?mathScore?+?““?+?physicsScore?+?““	+?chemicalScore?+?““?+?englishScore?+?“）“;
String?str?=?““;
Connection?con;
Statement?sql;
try?{
	con?=?DriverManager.getConnection（“jdbc:sqlserver://127.0.0.1:1433;DatabaseName=UserDB““sa“?“123“）;
	sql?=?con.createStatement（）;
	if?（number.length（）?>?0）?{
		int?m?=?sql.executeUpdate（insertCondition）;
		if?（m?!=?0）?{
			str?=?“對表中添加“?+?m?+?“條記錄成功“;
		}?else?{
			str?=?“添加記錄失敗“;
		}
	}?else?{
		str?=?“必須要有學(xué)號“;
	}
	con.close（）;
}?catch?（SQLException?e）?{
	str?=?“輸入的序號不允許重復(fù)“?+?e;
}
return?str;
}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-05-12?08:57??StartProj\
?????文件?????????444??2015-05-10?21:53??StartProj\.classpath
?????目錄???????????0??2015-06-25?14:01??StartProj\.myeclipse\
?????文件?????????300??2015-05-12?00:11??StartProj\.mymetadata
?????文件????????1415??2015-05-08?15:04??StartProj\.project
?????目錄???????????0??2015-05-12?08:57??StartProj\.settings\
?????文件?????????500??2015-05-08?14:53??StartProj\.settings\.jsdtscope
?????文件??????????49??2015-05-08?14:53??StartProj\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-05-08?14:53??StartProj\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件????????2294??2015-05-12?00:24??StartProj\AddBean.java
?????文件????????2074??2015-05-12?00:24??StartProj\DelBean.java
?????文件????????2532??2015-05-12?00:24??StartProj\QueryBean.java
?????文件????????2556??2015-05-12?00:24??StartProj\RenewBean.java
?????目錄???????????0??2015-05-12?08:57??StartProj\WebRoot\
?????目錄???????????0??2015-05-12?08:57??StartProj\WebRoot\meta-INF\
?????文件??????????36??2015-05-08?14:53??StartProj\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2015-05-12?08:57??StartProj\WebRoot\WEB-INF\
?????目錄???????????0??2015-05-12?08:57??StartProj\WebRoot\WEB-INF\classes\
?????目錄???????????0??2015-05-12?08:57??StartProj\WebRoot\WEB-INF\classes\user\
?????文件????????3853??2015-05-12?00:20??StartProj\WebRoot\WEB-INF\classes\user\AddBean.class
?????文件????????3049??2015-05-12?00:20??StartProj\WebRoot\WEB-INF\classes\user\DelBean.class
?????文件????????3727??2015-05-12?00:20??StartProj\WebRoot\WEB-INF\classes\user\QueryBean.class
?????文件????????4081??2015-05-12?00:20??StartProj\WebRoot\WEB-INF\classes\user\RenewBean.class
?????目錄???????????0??2015-06-25?14:01??StartProj\WebRoot\WEB-INF\lib\
?????文件?????????371??2015-05-08?14:53??StartProj\WebRoot\WEB-INF\web.xml
?????文件????????1709??2015-05-12?00:21??StartProj\WebRoot\add.jsp
?????文件????????1309??2015-05-12?00:24??StartProj\WebRoot\delete.jsp
?????文件?????????834??2015-05-08?14:53??StartProj\WebRoot\index.jsp
?????文件?????????728??2015-05-08?15:05??StartProj\WebRoot\mainPage.jsp
?????文件????????1761??2015-05-10?21:55??StartProj\WebRoot\renew.jsp
?????目錄???????????0??2015-05-12?08:57??StartProj\src\
............此處省略5個文件信息