Category

Development Platform
Home > SourceCode/Document > Java Develop > Jsp/Servlet > View Code
ManagerCollegeStudentInfo.java
Package: JSP.rar　[view]
Upload User: tian320582
Upload Date: 2007-08-23
Package Size: 173k
Code Size: 13k
Category:

Jsp/Servlet

Development Platform:

Java

ManagerCollegeStudentInfo.java：Code Content
  1. package internetsignup;
  2. import java.sql.*;
  3. public class ManagerCollegeStudentInfo
  4. {
  5. private String userName="";
  6. private String userPassword="";
  7. private String speciality="";
  8. private String signSelect="";
  9. private String sname="";
  10. private String sex="";
  11. private String birthday="";
  12. private String nation="";
  13. private String identityNo="";
  14. private String ifMember="";
  15. private String ownAddress="";
  16. private String graduateSchool="";
  17. private String signType="";
  18. private String address="";
  19. private String mailNo="";
  20. private String fatherName="";
  21. private String fatherJob="";
  22. private String fatherPhone="";
  23. private String motherName="";
  24. private String motherJob="";
  25. private String motherPhone="";
  26. private String cultureExtent="";
  27. private String score="";
  28. private String housePhone="";
  29. private String mobile="";
  30. private String remark="";
  31. private String schoolOpinion="";
  32. private String signupDate="";
  34. Connection conn=null;
  35. ResultSet rs=null;
  36. Statement stmt=null;
  38. public void setUserName(String userName)
  39. {
  40. this.userName=userName;
  41. }
  43. public void setUserPassword(String userPassword)
  44. {
  45. this.userPassword=userPassword;
  46. }
  48. public void setSpeciality(String speciality)
  49. {
  50. this.speciality=speciality;
  51. }
  53. public void setSignSelect(String signSelect)
  54. {
  55. this.signSelect=signSelect;
  56. }
  58. public void setSname(String sname)
  59. {
  60. this.sname=sname;
  61. }
  63. public void setSex(String sex)
  64. {
  65. this.sex=sex;
  66. }
  68. public void setBirthday(String birthday)
  69. {
  70. this.birthday=birthday;
  71. }
  73. public void setNation(String nation)
  74. {
  75. this.nation=nation;
  76. }
  78. public void setIdentityNo(String identityNo)
  79. {
  80. this.identityNo=identityNo;
  81. }
  83. public void setIfMember(String ifMember)
  84. {
  85. this.ifMember=ifMember;
  86. }
  88. public void setOwnAddress(String ownAddress)
  89. {
  90. this.ownAddress=ownAddress;
  91. }
  93. public void setGraduateSchool(String graduateSchool)
  94. {
  95. this.graduateSchool=graduateSchool;
  96. }
  98. public void setSignType(String signType)
  99. {
  100. this.signType=signType;
  101. }
  103. public void setAddress(String address)
  104. {
  105. this.address=address;
  106. }
  108. public void setMailNo(String mailNo)
  109. {
  110. this.mailNo=mailNo;
  111. }
  113. public void setFatherName(String fatherName)
  114. {
  115. this.fatherName=fatherName;
  116. }
  118. public void setFatherJob(String fatherJob)
  119. {
  120. this.fatherJob=fatherJob;
  121. }
  123. public void setFatherPhone(String fatherPhone)
  124. {
  125. this.fatherPhone=fatherPhone;
  126. }
  128. public void setMotherName(String motherName)
  129. {
  130. this.motherName=motherName;
  131. }
  133. public void setMotherJob(String motherJob)
  134. {
  135. this.motherJob=motherJob;
  136. }
  138. public void setMotherPhone(String motherPhone)
  139. {
  140. this.motherPhone=motherPhone;
  141. }
  143. public void setCultureExtent(String cultureExtent)
  144. {
  145. this.cultureExtent=cultureExtent;
  146. }
  148. public void setScore(String score)
  149. {
  150. this.score=score;
  151. }
  153. public void setHousePhone(String housePhone)
  154. {
  155. this.housePhone=housePhone;
  156. }
  158. public void setMobile(String mobile)
  159. {
  160. this.mobile=mobile;
  161. }
  163. public void setRemark(String remark)
  164. {
  165. this.remark=remark;
  166. }
  168. public void setSchoolOpinion(String schoolOpinion)
  169. {
  170. this.schoolOpinion=schoolOpinion;
  171. }
  173. public void setSignupDate(String signupDate)
  174. {
  175. this.signupDate=signupDate;
  176. }
  178. public String getUserName()
  179. {
  180. return userName;
  181. }
  183. public String getUserPassword()
  184. {
  185. return userPassword;
  186. }
  188. public String getSpeciality()
  189. {
  190. return speciality;
  191. }
  193. public String getSignSelect()
  194. {
  195. return signSelect;
  196. }
  198. public String getSname()
  199. {
  200. return sname;
  201. }
  203. public String getSex()
  204. {
  205. return sex;
  206. }
  208. public String getBirthday()
  209. {
  210. return birthday;
  211. }
  213. public String getNation()
  214. {
  215. return nation;
  216. }
  218. public String getIdentityNo()
  219. {
  220. return identityNo;
  221. }
  223. public String getIfMember()
  224. {
  225. return ifMember;
  226. }
  228. public String getOwnAddress()
  229. {
  230. return ownAddress;
  231. }
  233. public String getGraduateSchool()
  234. {
  235. return graduateSchool;
  236. }
  238. public String getSignType()
  239. {
  240. return signType;
  241. }
  243. public String getAddress()
  244. {
  245. return address;
  246. }
  248. public String getMailNo()
  249. {
  250. return mailNo;
  251. }
  253. public String getFatherName()
  254. {
  255. return fatherName;
  256. }
  258. public String getFatherJob()
  259. {
  260. return fatherJob;
  261. }
  263. public String getFatherPhone()
  264. {
  265. return fatherPhone;
  266. }
  268. public String getMotherName()
  269. {
  270. return motherName;
  271. }
  273. public String getMotherJob()
  274. {
  275. return motherJob;
  276. }
  278. public String getMotherPhone()
  279. {
  280. return motherPhone;
  281. }
  282. public String getCultureExtent()
  283. {
  284. return cultureExtent;
  285. }
  287. public String getScore()
  288. {
  289. return score;
  290. }
  292. public String getHousePhone()
  293. {
  294. return housePhone;
  295. }
  297. public String getMobile()
  298. {
  299. return mobile;
  300. }
  302. public String getRemark()
  303. {
  304. return remark;
  305. }
  307. public String getSchoolOpinion()
  308. {
  309. return schoolOpinion;
  310. }
  312. public String getSignupDate()
  313. {
  314. return signupDate;
  315. }
  317. public ManagerCollegeStudentInfo()
  318. {
  319. try
  320. {
  321. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  322. }
  323. catch(ClassNotFoundException e)
  324. {
  325. System.out.println(e);
  326. }
  327. }
  329. public int selectUserNameMessage()
  330. {
  331. try
  332. {
  333. conn=DriverManager.getConnection("jdbc:odbc:College","njgcxx","njgcxx");
  334. stmt=conn.createStatement();
  335. String sql="select * from CollegeStudentInfo where userName='"+userName+"'";
  336. rs=stmt.executeQuery(sql);
  337. if(rs.next())
  338. {
  339. userPassword=rs.getString("userPassword").trim();
  340. speciality=rs.getString("speciality").trim();
  341. signSelect=rs.getString("signSelect").trim();
  342. sname=rs.getString("sname").trim();
  343. sex=rs.getString("sex").trim();
  344. birthday=rs.getString("birthday").trim();
  345. nation=rs.getString("nation").trim();
  346. identityNo=rs.getString("identityNo").trim();
  347. ifMember=rs.getString("ifMember").trim();
  348. ownAddress=rs.getString("ownAddress").trim();
  349. graduateSchool=rs.getString("graduateSchool").trim();
  350. signType=rs.getString("signType").trim();
  351. address=rs.getString("address").trim();
  352. mailNo=rs.getString("mailNo").trim();
  353. fatherName=rs.getString("fatherName").trim();
  354. fatherJob=rs.getString("fatherJob").trim();
  355. fatherPhone=rs.getString("fatherPhone").trim();
  356. motherName=rs.getString("motherName").trim();
  357. motherJob=rs.getString("motherJob").trim();
  358. motherPhone=rs.getString("motherPhone").trim();
  359. cultureExtent=rs.getString("cultureExtent").trim();
  360. score=rs.getString("score").trim();
  361. housePhone=rs.getString("housePhone").trim();
  362. mobile=rs.getString("mobile").trim();
  363. remark=rs.getString("remark").trim();
  364. schoolOpinion=rs.getString("schoolOpinion").trim();
  365. signupDate=rs.getString("signupDate").trim();
  366. return 1;
  367. }
  368. else
  369. {
  370. return 0;
  371. }
  372. }
  373. catch(Exception e)
  374. {
  375. return 0;
  376. }
  377. finally
  378.         {
  379.          try{rs.close();stmt.close();conn.close();}
  380.          catch(Exception e){}
  381.         }  
  382. }
  384. public int selectSignupDateMessage()
  385. {
  386. try
  387. {
  388. conn=DriverManager.getConnection("jdbc:odbc:College","njgcxx","njgcxx");
  389. stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
  390. String sql="select * from CollegeStudentInfo where signupDate='"+signupDate+"'";
  391. rs=stmt.executeQuery(sql);
  392. if(rs.next())
  393. {
  394. userName=rs.getString("userName").trim();
  395. userPassword=rs.getString("userPassword").trim();
  396. speciality=rs.getString("speciality").trim();
  397. signSelect=rs.getString("signSelect").trim();
  398. sname=rs.getString("sname").trim();
  399. sex=rs.getString("sex").trim();
  400. birthday=rs.getString("birthday").trim();
  401. nation=rs.getString("nation").trim();
  402. identityNo=rs.getString("identityNo").trim();
  403. ifMember=rs.getString("ifMember").trim();
  404. ownAddress=rs.getString("ownAddress").trim();
  405. graduateSchool=rs.getString("graduateSchool").trim();
  406. signType=rs.getString("signType").trim();
  407. address=rs.getString("address").trim();
  408. mailNo=rs.getString("mailNo").trim();
  409. fatherName=rs.getString("fatherName").trim();
  410. fatherJob=rs.getString("fatherJob").trim();
  411. fatherPhone=rs.getString("fatherPhone").trim();
  412. motherName=rs.getString("motherName").trim();
  413. motherJob=rs.getString("motherJob").trim();
  414. motherPhone=rs.getString("motherPhone").trim();
  415. cultureExtent=rs.getString("cultureExtent").trim();
  416. score=rs.getString("score").trim();
  417. housePhone=rs.getString("housePhone").trim();
  418. mobile=rs.getString("mobile").trim();
  419. remark=rs.getString("remark").trim();
  420. schoolOpinion=rs.getString("schoolOpinion").trim();
  421. signupDate=rs.getString("signupDate").trim();
  422. return 1;
  423. }
  424. else
  425. {
  426. userName="";
  427. userPassword="";
  428. speciality="";
  429. signSelect="";
  430. sname="";
  431. sex="";
  432. birthday="";
  433. nation="";
  434. identityNo="";
  435. ifMember="";
  436. ownAddress="";
  437. graduateSchool="";
  438. signType="";
  439. address="";
  440. mailNo="";
  441. fatherName="";
  442. fatherJob="";
  443. fatherPhone="";
  444. motherName="";
  445. motherJob="";
  446. motherPhone="";
  447. cultureExtent="";
  448. score="";
  449. housePhone="";
  450. mobile="";
  451. remark="";
  452. schoolOpinion="";
  453. signupDate="";
  454. return 0;
  455. }
  456. }
  457. catch(Exception e)
  458. {
  459. return 0;
  460. }
  461. }
  463. public int count()
  464. {
  465. int i=1;
  466. try
  467. {
  468. while(rs.next())
  469.     {
  470.     i++;
  471.     }
  472.     rs.first();     
  473.     return i;
  474.     }
  475.     catch(Exception e){System.out.println(e.toString());return 0;}
  477. }
  479. public int MoveNextmessage()
  480. {
  481. try
  482. {
  483. if(rs.next())
  484. {
  485. userName=rs.getString("userName").trim();
  486. userPassword=rs.getString("userPassword").trim();
  487. speciality=rs.getString("speciality").trim();
  488. signSelect=rs.getString("signSelect").trim();
  489. sname=rs.getString("sname").trim();
  490. sex=rs.getString("sex").trim();
  491. birthday=rs.getString("birthday").trim();
  492. nation=rs.getString("nation").trim();
  493. identityNo=rs.getString("identityNo").trim();
  494. ifMember=rs.getString("ifMember").trim();
  495. ownAddress=rs.getString("ownAddress").trim();
  496. graduateSchool=rs.getString("graduateSchool").trim();
  497. signType=rs.getString("signType").trim();
  498. address=rs.getString("address").trim();
  499. mailNo=rs.getString("mailNo").trim();
  500. fatherName=rs.getString("fatherName").trim();
  501. fatherJob=rs.getString("fatherJob").trim();
  502. fatherPhone=rs.getString("fatherPhone").trim();
  503. motherName=rs.getString("motherName").trim();
  504. motherJob=rs.getString("motherJob").trim();
  505. motherPhone=rs.getString("motherPhone").trim();
  506. cultureExtent=rs.getString("cultureExtent").trim();
  507. score=rs.getString("score").trim();
  508. housePhone=rs.getString("housePhone").trim();
  509. mobile=rs.getString("mobile").trim();
  510. remark=rs.getString("remark").trim();
  511. schoolOpinion=rs.getString("schoolOpinion").trim();
  512. signupDate=rs.getString("signupDate").trim();
  513. return 1;
  514. }
  515. else
  516. {
  517. userName="";
  518. userPassword="";
  519. speciality="";
  520. signSelect="";
  521. sname="";
  522. sex="";
  523. birthday="";
  524. nation="";
  525. identityNo="";
  526. ifMember="";
  527. ownAddress="";
  528. graduateSchool="";
  529. signType="";
  530. address="";
  531. mailNo="";
  532. fatherName="";
  533. fatherJob="";
  534. fatherPhone="";
  535. motherName="";
  536. motherJob="";
  537. motherPhone="";
  538. cultureExtent="";
  539. score="";
  540. housePhone="";
  541. mobile="";
  542. remark="";
  543. schoolOpinion="";
  544. signupDate="";
  545. return 0;
  546. }
  547. }
  548. catch(Exception e)
  549. {
  550. return 0;
  551. }
  552. }
  554. public void closeMessage()
  555. {
  556. try
  557. {
  558. rs.close();
  559. stmt.close();
  560. conn.close();
  561. }
  562. catch(Exception e)
  563. {
  564. System.out.println(e.toString());
  565. }
  566. }
  568. public int updateMessage()
  569. {
  570. try
  571. {
  572. conn=DriverManager.getConnection("jdbc:odbc:College","njgcxx","njgcxx");
  573. stmt=conn.createStatement();
  574. String sql="update CollegeStudentInfo set speciality='"+
  575. speciality+"',signSelect='"+signSelect+"',sname='"+sname+"',sex='"+sex+"',birthday='"
  576. +birthday+"',nation='"+nation+"',identityNo='"+identityNo+"',ifMember='"+ifMember+"',ownAddress='"+ownAddress+"',graduateSchool='"+graduateSchool+"',signType='"+signType
  577. +"',address='"+address+"',mailNo='"+mailNo+"',fatherName='"+fatherName+"',fatherJob='"+fatherJob+"',fatherPhone='"+fatherPhone+"',motherName='"
  578. +motherName+"',motherJob='"+motherJob+"',motherPhone='"+motherPhone+"',cultureExtent='"+cultureExtent+"',score='"+score
  579. +"',housePhone='"+housePhone+"',mobile='"+mobile+"',remark='"+remark+"',schoolOpinion='"+schoolOpinion+"' where userName='"+userName+"'";
  580. int i=stmt.executeUpdate(sql);
  581. return i;
  582. }
  583. catch(Exception e)
  584. {
  585. System.out.println(e);
  586. return 0;
  587. }
  588. finally
  589.         {
  590.          try{stmt.close();conn.close();}
  591.          catch(Exception e){}
  592.         }  
  593. }
  595. public int deleteMessage()
  596. {
  597. try
  598. {
  599. conn=DriverManager.getConnection("jdbc:odbc:College","njgcxx","njgcxx");
  600. stmt=conn.createStatement();
  601. String sql="delete from CollegeStudentInfo where userName='"+userName+"'";
  602. int i=stmt.executeUpdate(sql);
  603. return i;
  604. }
  605. catch(Exception e)
  606. {
  607. System.out.println(e);
  608. return 0;
  609. }
  610. finally
  611.         {
  612.          try{stmt.close();conn.close();}
  613.          catch(Exception e){}
  614.         }  
  615. }
  616. }