public class TaskJob {
public void job1() throws SQLException
{
java.sql.Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
try{
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/itasset2?characterEncoding=utf-
8","root","root");
stmt = conn.createStatement();
rs=stmt.executeQuery("select * from birth_teacher");
while(rs.next())
{
String messag="";
String name=rs.getString("teacherName");
String gonghui=rs.getString("teacherGonghui");
String birth=rs.getString("teacherBirth");
String sex=rs.getString("teacherSex");
int phonenum=rs.getInt("teacherPhoneNumber");
int a=rs.getInt("age");
System.out.println(name);
System.out.println(gonghui);
System.out.println(birth);
System.out.println(sex);
System.out.println(phonenum);
System.out.println(a);
if(sex.equals("男"))
{
if(a<35)
{
messag="感谢你在最好的年华来到xxx并将青春奉献在这里,xxx"+gonghui+"工会祝
您"+a+"岁生日快乐,愿与你在将来的日子里一同成就自己建设xxx。";
}
if(a>=35&&a<=50)
{
messag="感谢您一直以来为xxx所付出的汗水,在您"+a+"岁生日的到来之际,
xxx"+gonghui+"工会祝您生日快乐,愿与您在这壮年之际成为xxx的中流砥柱,一同见证xxx走向辉煌。";
}
if(a>50&&a<=60)
{
messag="感谢您无数个日夜的坚守与付出,正是因为您的这么多年坚守与付出xxx才
能有今日长足的进步,xxx"+gonghui+"工会祝您"+a+"岁生日快乐,愿您在今后的日子里身体健康,并与您一起见证xxx走向辉煌。";
}
if(a>=61)
{
messag="感谢您为的建设奉献了几十年的光阴,在您"+a+"岁生日的到来之
际,"+gonghui+"工会祝您生日快乐,愿您在这退休的闲暇时光里身体健康。";
}
int result=stmt.executeUpdate("insert into birth_message
(teacherName,teacherBirth,message) values('"+ name + "','"+ birth +"','"+ messag +"')");
System.out.println(messag);
}
else
{
Statement st = conn.createStatement();
if(a<35)
{
messag="感谢你在最好的年华来到并将青春奉献在这里,"+gonghui+"工会祝您"+a+"
岁生日快乐,愿与你在将来的日子里一同成就自己建设xxx。";
}
if(a>=35&&a<=50)
{
messag="感谢您一直以来为所付出的汗水,在您"+a+"岁生日的到来之
际,"+gonghui+"工会祝您生日快乐,愿与您在这壮年之际成为中流砥柱,一同见证走向辉煌。";
}
if(a>=51)
{
messag="感谢您为的建设奉献了几十年的光阴,在您"+a+"岁生日的到来之
际,"+gonghui+"工会祝您生日快乐,愿您在这退休的闲暇时光里身体健康。";
}
//new MessageSend(phonenum, id, gonghui, name).start();
int result=st.executeUpdate("insert into birth_message
(teacherName,teacherBirth,message) values('"+ name + "','"+ birth +"','"+ messag +"')");
System.out.println(messag);
}
}
}
catch(SQLException e){
System.out.println("发生了异常"+e.getMessage());
}
finally{
if(rs!=null)
{
rs.close();
}
if(stmt!=null)
{
stmt.close();
}
if(conn!=null)
{
conn.close();
}
}
}
}
输出结果最后一行一直是Operation not allowed after ResultSet closed