• Java项目：JSP家教服务找家教平台网站项目

    作者主页：夜未央5788

     简介：Java领域优质创作者、Java项目、学习资料、技术互助

    文末获取源码

    项目介绍

    该项目分为前后台，前台为教师、学生登录，后台为管理员登录；

    管理员角色包含以下功能：

    管理员登陆,教员信息管理,学生需求管理,订单管理,留言管理等功能。

    教师角色包含以下功能：
    教师登录,查看学员需求,提交反馈,个人资料管理,证件认证,授课信息管理,时间安排查看,我的订单查看,密码修改等功能。

    学生角色包含以下功能：
    学生登录,学生首页,查看学生的需求,查找教员,查看老师基本信息,预约教师,查看我的需求,学员发布需求,我的订单查看等功能。

    环境需要

    1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。
    2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA;
    3.tomcat环境：Tomcat 7.x,8.x,9.x版本均可
    4.硬件环境：windows 7/8/10 1G内存以上；或者 Mac OS； 

    5.数据库：MySql 5.7版本；

    6.是否Maven项目：否

    技术栈

    JSP+CSS+JavaScript+jQuery+bootstrap+servlet+mysql

    使用说明

    1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
    2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
    若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
    3. 将项目中dao/Conn.java配置文件中的数据库配置改为自己的配置;

    4. 运行项目，输入localhost:8080/jsp_jiajiao_site 登录

    注：tomcat中配置路径须为jsp_jiajiao_site，否则会有异常

    管理员账号/密码：admin/admin
    教员账号/密码： 13022502400/123456

    学生账号/密码： 13022502401/123456

    运行截图

    学生角色

     

     

     

     

    教师角色

     

     

     

     

     

    管理员角色 

     

     

     

     

     

    相关代码 

    OrderDB

    1. package com.soft.dao;
    2.  
    3. import java.sql.Connection;
    4. import java.sql.PreparedStatement;
    5. import java.sql.ResultSet;
    6. import java.sql.SQLException;
    7. import java.util.ArrayList;
    8.  
    9. import com.soft.Bean.OrderBean;
    10. import com.soft.Bean.StudentBean;
    11.  
    12. public class OrderDB {
    13. 	private Connection conn=null;
    14. 	private PreparedStatement ps=null;
    15. 	private ResultSet rs=null;
    16. 	
    17. 	private int pageSize=4;//一页显示几条记录
    18. 	private int rowCount=0;//共有几条记录(查表)
    19. 	private int pageCount=0;//共有几页(计算)
    20. 	
    21. 	public int getPageCount(){//得到总页数
    22. 		conn=Conn.getConnect();
    23. 		String sql="select count(*) from reservation";
    24. 		try {
    25. 			ps=conn.prepareStatement(sql);
    26. 			rs=ps.executeQuery();
    27. 			if(rs.next()){
    28. 				rowCount=rs.getInt(1);
    29. 			}
    30. 			//计算pageCount,这里的算法很多，可以自己设计
    31. 			if(rowCount%pageSize==0){
    32. 				pageCount=rowCount/pageSize;
    33. 			}else{
    34. 				pageCount=rowCount/pageSize+1;
    35. 			}
    36. 			
    37. 		}
    38. 		catch (SQLException e) {
    39. 			// TODO Auto-generated catch block
    40. 			e.printStackTrace();
    41. 		}finally{
    42. 			this.close();
    43. 		}
    44. 		return pageCount;
    45. 	}
    46. 	public ArrayList getOrderPage(int pageNow){//-----订单分页给定页数的数据------------
    47. 		ArrayList order=new ArrayList();
    48. 		conn=Conn.getConnect();
    49. 		String sql="select * from reservation ORDER BY create_time DESC limit ?,?";
    50. 		try {
    51. 			ps=conn.prepareStatement(sql);
    52. 			ps.setInt(1,4*pageNow-4);
    53. 			ps.setInt(2,pageSize);
    54. 			rs=ps.executeQuery();
    55. 			while(rs.next()){
    56. 				OrderBean ob=new OrderBean();
    57. 				ob.setId(rs.getInt("id"));
    58. 				ob.setT_name(rs.getString("t_name"));
    59. 				ob.setT_tell(rs.getString("t_tell"));
    60. 				ob.setS_name(rs.getString("s_name"));
    61. 				ob.setS_tell(rs.getString("s_tell"));
    62. 				ob.setSubject(rs.getString("subject"));
    63. 				ob.setRtime(rs.getString("Rtime"));
    64. 				ob.setRstatu(rs.getString("Rstatu"));
    65. 				ob.setAddress(rs.getString("address"));
    66. 				ob.setMethod(rs.getString("method"));
    67. 				ob.setMoney(rs.getString("money"));
    68. 				ob.setRemark(rs.getString("remark"));
    69. 				ob.setCreate_time(rs.getString("create_time"));
    70. 				order.add(ob);
    71. 			}
    72. 		}
    73. 		catch (SQLException e) {
    74. 			// TODO Auto-generated catch block
    75. 			e.printStackTrace();
    76. 		}finally{
    77. 			this.close();
    78. 		}
    79. 		return order;
    80. 	}
    81. 	
    82. 	public boolean UpdateOrder(String flag,String id,String t_tell,String s_tell){
    83. 		boolean tt=false;
    84. 		conn=Conn.getConnect();
    85. 		String sql="update reservation set Rstatu='"+flag+"' where id="+id;
    86. 		try {
    87. 			ps=conn.prepareStatement(sql);
    88. 			int i=ps.executeUpdate();
    89. 			if(i>0){
    90. 				String sql1="update teacher set authentication='"+flag+"' where tell='"+t_tell+"'";
    91. 				String sql2="update student set authentication='"+flag+"' where tell='"+s_tell+"'";
    92. 				ps=conn.prepareStatement(sql1);
    93. 				ps.executeUpdate();
    94. 				ps=conn.prepareStatement(sql2);
    95. 				ps.executeUpdate();
    96. 				tt=true;
    97. 			}
    98. 		}
    99. 		catch (SQLException e) {
    100. 			// TODO Auto-generated catch block
    101. 			e.printStackTrace();
    102. 		}finally{
    103. 			this.close();
    104. 		}
    105. 		return tt;
    106. 	}
    107. 	public boolean dellOrder(String id){
    108. 		boolean tt=false;
    109. 		conn=Conn.getConnect();
    110. 		String sql="delete from reservation where id="+id;
    111. 		try {
    112. 			ps=conn.prepareStatement(sql);
    113. 			int i=ps.executeUpdate();
    114. 			if(i>0){
    115. 				tt=true;
    116. 			}
    117. 		}
    118. 		catch (SQLException e) {
    119. 			// TODO Auto-generated catch block
    120. 			e.printStackTrace();
    121. 		}finally{
    122. 			this.close();
    123. 		}
    124. 		return tt;
    125. 	}
    126. 	
    127. 	
    128. 	
    129. 	
    130. 	
    131. 	
    132. 	
    133. 	
    134. 	
    135. 	
    136. 	
    137. 	
    138. 	
    139. 	
    140. 	
    141. 	
    142. 	public void close(){
    143. 		try {
    144. 			if(rs!=null){
    145. 				rs.close();
    146. 				rs=null;
    147. 			}
    148. 			if(ps!=null){
    149. 				ps.close();
    150. 				ps=null;
    151. 			}
    152. 			if(conn!=null){
    153. 				conn.close();
    154. 				conn=null;
    155. 			}
    156. 		} catch (SQLException e) {
    157. 			// TODO Auto-generated catch block
    158. 			e.printStackTrace();
    159. 		}
    160. 	}
    161. }

    StudentDB

    1. package com.soft.dao;
    2.  
    3. import java.sql.Connection;
    4.  
    5. import java.sql.PreparedStatement;
    6. import java.sql.ResultSet;
    7. import java.sql.SQLException;
    8. import java.text.SimpleDateFormat;
    9. import java.util.ArrayList;
    10. import java.util.Date;
    11. import java.util.List;
    12.  
    13. import com.soft.Bean.StudentBean;
    14. import com.soft.Bean.TeacherBean;
    15.  
    16. public class StudentDB {
    17. 	private Connection conn=null;
    18. 	private PreparedStatement ps=null;
    19. 	private ResultSet rs=null;
    20. 	
    21. 	private int pageSize=4;//一页显示几条记录
    22. 	private int rowCount=0;//共有几条记录(查表)
    23. 	private int pageCount=0;//共有几页(计算)
    24. 	
    25. 	public int getPageCount(){//得到总页数
    26. 		conn=Conn.getConnect();
    27. 		String sql="select count(*) from student";
    28. 		try {
    29. 			ps=conn.prepareStatement(sql);
    30. 			rs=ps.executeQuery();
    31. 			if(rs.next()){
    32. 				rowCount=rs.getInt(1);
    33. 			}
    34. 			//计算pageCount,这里的算法很多，可以自己设计
    35. 			if(rowCount%pageSize==0){
    36. 				pageCount=rowCount/pageSize;
    37. 			}else{
    38. 				pageCount=rowCount/pageSize+1;
    39. 			}
    40. 			
    41. 		}
    42. 		catch (SQLException e) {
    43. 			// TODO Auto-generated catch block
    44. 			e.printStackTrace();
    45. 		}finally{
    46. 			this.close();
    47. 		}
    48. 		return pageCount;
    49. 	}
    50. 	
    51. 	
    52. 	public ArrayList getTeacherPage(int pageNow){//------学生分页给定页数的数据------------
    53. 		ArrayList list=new ArrayList();
    54. 		conn=Conn.getConnect();
    55. 		String sql="select * from student ORDER BY create_time DESC limit ?,?";
    56. 		try {
    57. 			ps=conn.prepareStatement(sql);
    58. 			ps.setInt(1,4*pageNow-4);
    59. 			ps.setInt(2,pageSize);
    60. 			rs=ps.executeQuery();
    61. 			while(rs.next()){
    62. 				StudentBean bean=new StudentBean();
    63. 				bean.setId(rs.getInt("id"));
    64. 				bean.setU_id(rs.getInt("u_id"));
    65. 				bean.setS_name(rs.getString("s_name"));
    66. 				bean.setSex(rs.getString("sex"));
    67. 				bean.setAge(rs.getString("age"));
    68. 				bean.setTell(rs.getString("tell"));
    69. 				bean.setTime(rs.getString("time"));
    70. 				bean.setArea(rs.getString("area"));
    71. 				bean.setAddress(rs.getString("address"));
    72. 				bean.setGrade(rs.getString("grade"));
    73. 				bean.setStatus(rs.getString("status"));
    74. 				bean.setRequestSex(rs.getString("requestSex"));
    75. 				bean.setRequestMoney(rs.getString("requestMoney"));
    76. 				bean.setPid(rs.getString("pid"));
    77. 				bean.setAuthentication(rs.getString("authentication"));
    78. 				bean.setCreate_time(rs.getString("create_time"));
    79. 				list.add(bean);
    80. 			}
    81. 		}
    82. 		catch (SQLException e) {
    83. 			// TODO Auto-generated catch block
    84. 			e.printStackTrace();
    85. 		}finally{
    86. 			this.close();
    87. 		}
    88. 		return list;
    89. 	}
    90. 	
    91. 	//查询单个学生的信息
    92. 	public StudentBean getStudentInfo(String u_id){
    93. 		conn=Conn.getConnect();
    94. 		StudentBean bean=new StudentBean();
    95. 		String sql="select * from student where u_id="+u_id;
    96. 		conn=Conn.getConnect();
    97. 		try {
    98. 			ps=conn.prepareStatement(sql);
    99. 			rs=ps.executeQuery();
    100. 			while(rs.next()){
    101. 				bean.setId(rs.getInt("id"));
    102. 				bean.setU_id(rs.getInt("u_id"));
    103. 				bean.setS_name(rs.getString("s_name"));
    104. 				bean.setSex(rs.getString("sex"));
    105. 				bean.setAge(rs.getString("age"));
    106. 				bean.setTell(rs.getString("tell"));
    107. 				bean.setTime(rs.getString("time"));
    108. 				bean.setArea(rs.getString("area"));
    109. 				bean.setAddress(rs.getString("address"));
    110. 				bean.setGrade(rs.getString("grade"));
    111. 				bean.setStatus(rs.getString("status"));
    112. 				bean.setRequestSex(rs.getString("requestSex"));
    113. 				bean.setRequestMoney(rs.getString("requestMoney"));
    114. 				bean.setPid(rs.getString("pid"));
    115. 				bean.setAuthentication(rs.getString("authentication"));
    116. 				bean.setCreate_time(rs.getString("create_time"));
    117. 				
    118. 			}
    119. 		}
    120. 		catch (SQLException e) {
    121. 			// TODO Auto-generated catch block
    122. 			e.printStackTrace();
    123. 		}finally{
    124. 			this.close();
    125. 		}
    126. 		/*
    127. 		 * 20167-12添加end
    128. 		 * 
    129. 		 * */
    130. 		
    131. 		return bean;
    132. 	}
    133. 	
    134. 	
    135. 	
    136. 		public boolean UpdateStudent(String name,String pid,String age,String sex,String time,String grade,String requestSex,String address,String status,String requestMoney,String tell){
    137. 		boolean tt=false;
    138. 		conn=Conn.getConnect();
    139. 		String sql = "update student set s_name='"+name+"',sex='"+sex+"',age='"+age+"',pid='"+pid+"',time='"+time+"',grade='"+grade+"',requestSex='"+requestSex+"',address='"+address+"',requestMoney='"+requestMoney+"',status='"+status+"',create_time=NOW()"+"  where tell='"+tell+"'";  
    140.         //String sql="update teacher set pid='"+pid+"'where id=1";
    141. 		//System.out.println("bb");
    142. 		try {
    143. 			ps=conn.prepareStatement(sql);
    144. 			//System.out.println(tt);
    145. 			int i=ps.executeUpdate();
    146. 			if(i>0){
    147. 				tt=true;
    148. 				System.out.print(tt);
    149. 			}
    150. 		} catch (SQLException e) {
    151. 			// TODO Auto-generated catch block
    152. 			e.printStackTrace();
    153. 		}
    154. 		return tt;
    155. 	}
    156. 	    public List Select(String tell){
    157. 	    	List student = new ArrayList();// 利用ArrayList类实例化List集合  
    158. 			conn=Conn.getConnect();
    159. 			String sql = "select * from student where tell='"+tell+"'";
    160. 			//System.out.println("21212");
    161. 	        try {
    162. 				ps=conn.prepareStatement(sql);
    163. 				rs=ps.executeQuery();
    164. 				//System.out.println("fsdfsd");
    165. 				while(rs.next()){
    166. 					//System.out.println("bb");
    167. 					String name=rs.getString("s_name");
    168. 					String pid=rs.getString("pid");
    169. 					String sex=rs.getString("sex");
    170. 					String age=rs.getString("age");
    171. 					String time=rs.getString("time");
    172. 					String grade=rs.getString("grade");
    173. 					String requestSex=rs.getString("requestSex");
    174. 					String address=rs.getString("address");
    175. 					String status=rs.getString("status");
    176. 					String requestMoney=rs.getString("requestMoney");
    177. 					//System.out.println(username);
    178. 					student.add(name);
    179. 					student.add(pid);
    180. 					student.add(age);
    181. 					student.add(sex);
    182. 					student.add(time);
    183. 					student.add(grade);
    184. 					student.add(requestSex);
    185. 					student.add(address);
    186. 					student.add(status);
    187. 					student.add(requestMoney);
    188. 					}
    189. 	        }catch (SQLException e) {
    190. 				// TODO Auto-generated catch block
    191. 				e.printStackTrace();
    192. 			}
    193. 			return student;
    194. 	    }
    195. 	    public boolean addOrder(String s_name,String t_name,String s_tell,String subject,String Rtime,String address,String method,String remark,String ttell,String money){
    196. 			boolean tt=false;
    197. 			conn=Conn.getConnect();
    198. 			SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    199. 			
    200. 			String sql = "insert into reservation(s_name, t_name, s_tell, subject, Rtime, Rstatu, create_time, address, method, remark,t_tell,money)values('"+s_name+"','"+t_name+"','"+s_tell+"','"+subject+"','"+Rtime+"','2','"+sdf.format(new Date())+"','"+address+"','"+method+"','"+remark+"','"+ttell+"','"+money+"')";  
    201. 	        //String sql="update teacher set pid='"+pid+"'where id=1";
    202. 			//System.out.println("bb");
    203. 			
    204. 			try {
    205. 				ps=conn.prepareStatement(sql);
    206. 				//System.out.println(tt);
    207. 				int i=ps.executeUpdate();
    208. 				if(i>0){
    209. 					tt=true;
    210. 					System.out.print(tt);
    211. 				}
    212. 			} catch (SQLException e) {
    213. 				// TODO Auto-generated catch block
    214. 				e.printStackTrace();
    215. 			}
    216. 			return tt;
    217. 		}
    218. 	
    219. 	    
    220. 	    public void close(){
    221.   			try {
    222.   				if(rs!=null){
    223.   					rs.close();
    224.   					rs=null;
    225.   				}
    226.   				if(ps!=null){
    227.   					ps.close();
    228.   					ps=null;
    229.   				}
    230.   				if(conn!=null){
    231.   					conn.close();
    232.   					conn=null;
    233.   				}
    234.   			} catch (SQLException e) {
    235.   				// TODO Auto-generated catch block
    236.   				e.printStackTrace();
    237.   			}
    238.   		}
    239. }

    TeacherDB

    1. package com.soft.dao;
    2.  
    3. import java.sql.Connection;
    4. import java.sql.PreparedStatement;
    5. import java.sql.ResultSet;
    6. import java.sql.SQLException;
    7. import java.util.ArrayList;
    8. import java.util.List;
    9.  
    10. import com.soft.Bean.LessionBean;
    11. import com.soft.Bean.OrderBean;
    12. import com.soft.Bean.TeacherBean;
    13.  
    14. public class TeacherDB {
    15. 	private Connection conn=null;
    16. 	private PreparedStatement ps=null;
    17. 	private ResultSet rs=null;
    18. 	
    19. 	private int pageSize=4;//一页显示几条记录
    20. 	private int rowCount=0;//共有几条记录(查表)
    21. 	private int pageCount=0;//共有几页(计算)
    22. 	
    23. 	public int getPageCount(){//得到总页数
    24. 		conn=Conn.getConnect();
    25. 		String sql="select count(*) from teacher";
    26. 		try {
    27. 			ps=conn.prepareStatement(sql);
    28. 			rs=ps.executeQuery();
    29. 			if(rs.next()){
    30. 				rowCount=rs.getInt(1);
    31. 			}
    32. 			//计算pageCount,这里的算法很多，可以自己设计
    33. 			if(rowCount%pageSize==0){
    34. 				pageCount=rowCount/pageSize;
    35. 			}else{
    36. 				pageCount=rowCount/pageSize+1;
    37. 			}
    38. 			
    39. 		}
    40. 		catch (SQLException e) {
    41. 			// TODO Auto-generated catch block
    42. 			e.printStackTrace();
    43. 		}finally{
    44. 			this.close();
    45. 		}
    46. 		return pageCount;
    47. 	}
    48. 	public ArrayList getTeacherPage(int pageNow){//------分页给定页数的数据------------
    49. 		ArrayList list=new ArrayList();
    50. 		conn=Conn.getConnect();
    51. 		String sql="select * from teacher ORDER BY create_time DESC limit ?,?";
    52. 		
    53. 		try {
    54. 			ps=conn.prepareStatement(sql);
    55. 			ps.setInt(1,4*pageNow-4);
    56. 			ps.setInt(2,pageSize);
    57. 			rs=ps.executeQuery();
    58. 			while(rs.next()){
    59. 				TeacherBean bean=new TeacherBean();
    60. 				bean.setId(rs.getInt("id"));
    61. 				bean.setU_id(rs.getInt("u_id"));
    62. 				bean.setPid(rs.getString("pid"));
    63. 				bean.setImages(rs.getString("images"));
    64. 				bean.setT_name(rs.getString("t_name"));
    65. 				bean.setSex(rs.getString("sex"));
    66. 				bean.setAge(rs.getString("age"));
    67. 				bean.setNationality(rs.getString("nationality"));
    68. 				bean.setTell(rs.getString("tell"));
    69. 				bean.setEmail(rs.getString("email"));
    70. 				bean.setMotto(rs.getString("motto"));
    71. 				bean.setIntroduce(rs.getString("introduce"));
    72. 				bean.setGraduate_school(rs.getString("graduate_school"));
    73. 				bean.setSpecialty(rs.getString("specialty"));
    74. 				bean.setEducation(rs.getString("education"));
    75. 				bean.setAddress(rs.getString("address"));
    76. 				bean.setAuthentication(rs.getString("authentication"));
    77. 				bean.setExperience(rs.getString("experience"));
    78. 				bean.setMoney(rs.getString("money"));
    79. 				bean.setTeach_time(rs.getString("teach_time"));
    80. 				bean.setSubject(rs.getString("subject"));//得到所查询的科目
    81. 				bean.setArea(rs.getString("area"));//得到授课区域
    82. 				bean.setCreate_time(rs.getString("create_time"));
    83. 				bean.setImageC(rs.getString("imageC"));
    84. 				bean.setImageE(rs.getString("imageE"));
    85. 				list.add(bean);
    86. 			}
    87. 		}
    88. 		catch (SQLException e) {
    89. 			// TODO Auto-generated catch block
    90. 			e.printStackTrace();
    91. 		}finally{
    92. 			this.close();
    93. 		}
    94. 		return list;
    95. 	}
    96. 	
    97. 	//搜索教员
    98. 	public ArrayList SearchTeacher(String s_where){
    99. 		ArrayList list=new ArrayList();
    100. 		conn=Conn.getConnect();
    101. 		String sql="select * from teacher where id is not null and authentication!='0' "+s_where+" order by create_time DESC";
    102. 		try {
    103. 			ps=conn.prepareStatement(sql);
    104. 			rs=ps.executeQuery();
    105. 				while(rs.next()){
    106. 					TeacherBean bean=new TeacherBean();
    107. 					bean.setId(rs.getInt("id"));
    108. 					bean.setU_id(rs.getInt("u_id"));
    109. 					bean.setPid(rs.getString("pid"));
    110. 					bean.setImages(rs.getString("images"));
    111. 					bean.setT_name(rs.getString("t_name"));
    112. 					bean.setSex(rs.getString("sex"));
    113. 					bean.setAge(rs.getString("age"));
    114. 					bean.setNationality(rs.getString("nationality"));
    115. 					bean.setTell(rs.getString("tell"));
    116. 					bean.setEmail(rs.getString("email"));
    117. 					bean.setMotto(rs.getString("motto"));
    118. 					bean.setIntroduce(rs.getString("introduce"));
    119. 					bean.setGraduate_school(rs.getString("graduate_school"));
    120. 					bean.setSpecialty(rs.getString("specialty"));
    121. 					bean.setEducation(rs.getString("education"));
    122. 					bean.setAddress(rs.getString("address"));
    123. 					bean.setAuthentication(rs.getString("authentication"));
    124. 					bean.setExperience(rs.getString("experience"));
    125. 					bean.setMoney(rs.getString("money"));
    126. 					bean.setTeach_time(rs.getString("teach_time"));
    127. 					bean.setSubject(rs.getString("subject"));//得到所查询的科目
    128. 					bean.setArea(rs.getString("area"));//得到授课区域
    129. 					bean.setCreate_time(rs.getString("create_time"));
    130. 					list.add(bean);
    131. 				}
    132. 		}
    133. 		catch (SQLException e) {
    134. 			// TODO Auto-generated catch block
    135. 			e.printStackTrace();
    136. 		}finally{
    137. 			this.close();
    138. 		}
    139. 		return list;
    140. 	}
    141. 	
    142. 	
    143. 	
    144. 	//查询所授科目
    145. 	public String subject(String tell){
    146. 			conn=Conn.getConnect();
    147. 			String tt="";
    148. 			String sql="select grade,subject from lesson where tell=?";
    149. 			String grade="";String subject="";
    150. 			try {
    151. 				ps=conn.prepareStatement(sql);
    152. 				ps.setString(1,tell);
    153. 				rs=ps.executeQuery();
    154. 				if(rs.next()){
    155. 					while(rs.next()){
    156. 						grade=rs.getString(1);
    157. 						subject=rs.getString(2);
    158. 						tt=tt+grade+subject+"|";
    159. 					}
    160. 				}else{
    161. 					tt="暂未设置";
    162. 				}
    163. 			sql="update teacher set subject='"+tt+"' where tell="+tell;
    164. 			ps=conn.prepareStatement(sql);
    165. 			ps.executeUpdate();
    166. 			
    167. 			System.out.println(tt);
    168. 			}
    169. 			catch (SQLException e) {
    170. 				// TODO Auto-generated catch block
    171. 				e.printStackTrace();
    172. 			}
    173. 			return tt;
    174. 		}
    175. 	
    176. 	
    177. 	
    178. 	//查询教授区域和地址
    179. 	public List getAddress(String tell){
    180. 		List teacher = new ArrayList();// 利用ArrayList类实例化List集合  
    181. 		conn=Conn.getConnect();
    182. 		System.out.println("===========查询授课区域==============");
    183. 		String sql="select area,address from teacher where tell='"+tell+"'";
    184. 		try {
    185. 			ps=conn.prepareStatement(sql);
    186. 			rs=ps.executeQuery();
    187. 			if(rs.next()){
    188. 				System.out.println(rs.getString("area"));
    189. 				String area=rs.getString("area");
    190. 				String address=rs.getString("address");
    191. 				teacher.add(area);
    192. 				teacher.add(address);
    193. 			}else{
    194. 				return null;
    195. 			}
    196. 			
    197. 		} catch (SQLException e) {
    198. 			// TODO Auto-generated catch block
    199. 			e.printStackTrace();
    200. 		}finally{
    201. 			this.close();
    202. 		}
    203. 		return teacher;
    204. 	}
    205. 	//修改教授区域和地址
    206. 	public boolean UpdateAddress(String area,String address,String tell){
    207. 		boolean tt=false;
    208. 		conn=Conn.getConnect();
    209. 		String sql="update teacher set area='"+area+"',address='"+address+"' where tell='"+tell+"'";
    210. 		try {
    211. 			ps=conn.prepareStatement(sql);
    212. 			int i=ps.executeUpdate();
    213. 			if(i>0){
    214. 				tt=true;
    215. 			}
    216. 		}
    217. 		catch (SQLException e) {
    218. 			// TODO Auto-generated catch block
    219. 			e.printStackTrace();
    220. 		}
    221. 		return tt;
    222. 	}
    223. 	
    224. 	
    225. 	//查询可授课表
    226. 	public ArrayList getLession(String tell){
    227. 		conn=Conn.getConnect();
    228. 		ArrayList lesson=new ArrayList();
    229. 		String sql="select id,grade,subject from lesson where tell='"+tell+"' ORDER BY id DESC";
    230. 		try {
    231. 			ps=conn.prepareStatement(sql);
    232. 			rs=ps.executeQuery();
    233. 			while(rs.next()){
    234. 				LessionBean lb=new LessionBean();
    235. 				lb.setId(rs.getInt(1));
    236. 				lb.setGrade(rs.getString(2));
    237. 				lb.setSubject(rs.getString(3));
    238. 				lesson.add(lb);
    239. 			}
    240. 		}
    241. 		catch (SQLException e) {
    242. 			// TODO Auto-generated catch block
    243. 			e.printStackTrace();
    244. 		}finally{
    245. 			this.close();
    246. 		}
    247. 		return lesson;
    248. 	}
    249. 	//添加可授课表
    250. 	public boolean setLession(String tell,String grade,String subject){
    251. 		boolean tt=false;
    252. 		conn=Conn.getConnect();
    253. 		String sql="insert into lesson(tell,grade,subject)values('"+tell+"','"+grade+"','"+subject+"')";
    254. 		try {
    255. 			ps=conn.prepareStatement(sql);
    256. 			int i=ps.executeUpdate();
    257. 			if(i>0){
    258. 				tt=true;
    259. 				subject(tell);//添加成功及时插入teacher表
    260. 			}
    261. 		}
    262. 		catch (SQLException e) {
    263. 			// TODO Auto-generated catch block
    264. 			e.printStackTrace();
    265. 		}
    266. 		return tt;
    267. 	}
    268. 	//删除授课信息
    269. 	public boolean dellLession(String id,String tell){
    270. 		boolean tt=false;
    271. 		conn=Conn.getConnect();
    272. 		String sql="delete from lesson where id="+id;
    273. 		try {
    274. 			ps=conn.prepareStatement(sql);
    275. 			int i=ps.executeUpdate();
    276. 			if(i>0){
    277. 				tt=true;
    278. 				subject(tell);//添加成功及时插入teacher表
    279. 			}
    280. 		}
    281. 		catch (SQLException e) {
    282. 			// TODO Auto-generated catch block
    283. 			e.printStackTrace();
    284. 		}finally{
    285. 			this.close();
    286. 		}
    287. 		return tt;
    288. 	}
    289. 	//查询头像
    290. 	public List selectImg(String tell){
    291. 		List list=new ArrayList();
    292. 		conn=Conn.getConnect();
    293. 		String sql="select images,imageC,imageE from teacher where tell="+tell;
    294. 		try {
    295. 			ps=conn.prepareStatement(sql);
    296. 			rs=ps.executeQuery();
    297. 			if(rs.next()){
    298. 				list.add(rs.getString("images"));
    299. 				list.add(rs.getString("imageC"));
    300. 				list.add(rs.getString("imageE"));
    301. 			}else{
    302. 				return null;
    303. 			}
    304. 		}
    305. 		catch (SQLException e) {
    306. 			// TODO Auto-generated catch block
    307. 			e.printStackTrace();
    308. 		}
    309. 		return list;
    310. 	}
    311. 	
    312. 	//更新头像------------------------------------------------------
    313. 	public boolean Updateimg(String path,String tell){
    314. 		boolean tt=false;
    315. 		conn=Conn.getConnect();
    316. 		try {
    317. 				String sql="update teacher set images='"+path+"' where tell="+tell;
    318. 				ps=conn.prepareStatement(sql);
    319. 				int i=ps.executeUpdate();
    320. 				if(i>0){
    321. 					tt=true;
    322. 				}
    323. 		}
    324. 		catch (SQLException e) {
    325. 			// TODO Auto-generated catch block
    326. 			e.printStackTrace();
    327. 		}finally{
    328. 			this.close();
    329. 		}
    330. 		return tt;
    331. 	}
    332. 	
    333. 	//更新身份图片------------------------------------------------------
    334. 		public boolean UpdatePidimg(String path,String tell){
    335. 			boolean tt=false;
    336. 			conn=Conn.getConnect();
    337. 			try {
    338. 					String sql="update teacher set imageC='"+path+"' where tell="+tell;
    339. 					ps=conn.prepareStatement(sql);
    340. 					int i=ps.executeUpdate();
    341. 					if(i>0){
    342. 						tt=true;
    343. 					}
    344. 			}
    345. 			catch (SQLException e) {
    346. 				// TODO Auto-generated catch block
    347. 				e.printStackTrace();
    348. 			}finally{
    349. 				this.close();
    350. 			}
    351. 			return tt;
    352. 		}
    353. 		//更新学历图片------------------------------------------------------
    354. 		public boolean UpdatEdueimg(String path,String tell){
    355. 			boolean tt=false;
    356. 			conn=Conn.getConnect();
    357. 			try {
    358. 					String sql="update teacher set imageE='"+path+"' where tell="+tell;
    359. 					ps=conn.prepareStatement(sql);
    360. 					int i=ps.executeUpdate();
    361. 					if(i>0){
    362. 						tt=true;
    363. 					}
    364. 			}
    365. 			catch (SQLException e) {
    366. 				// TODO Auto-generated catch block
    367. 				e.printStackTrace();
    368. 			}finally{
    369. 				this.close();
    370. 			}
    371. 			return tt;
    372. 		}
    373. 	
    374. 	
    375. 	
    376. 	
    377. 	
    378. 	
    379. 	
    380. 	
    381. 	
    382. 	
    383. 	
    384. 	
    385. 	/*
    386. 	 * 20167-12添加start
    387. 	 * 教员个人信息（主页）
    388. 	 * */
    389. 	public TeacherBean getTeacherInfo(String u_id){
    390. 		conn=Conn.getConnect();
    391. 		//ArrayList list=new ArrayList();
    392. 		TeacherBean bean=new TeacherBean();
    393. 		String sql="select * from teacher where u_id="+u_id;
    394. 		conn=Conn.getConnect();
    395. 		try {
    396. 			ps=conn.prepareStatement(sql);
    397. 			rs=ps.executeQuery();
    398. 			while(rs.next()){
    399. 				bean.setId(rs.getInt("id"));
    400. 				bean.setU_id(rs.getInt("u_id"));
    401. 				bean.setPid(rs.getString("pid"));
    402. 				bean.setImages(rs.getString("images"));
    403. 				bean.setT_name(rs.getString("t_name"));
    404. 				bean.setSex(rs.getString("sex"));
    405. 				bean.setAge(rs.getString("age"));
    406. 				bean.setNationality(rs.getString("nationality"));
    407. 				bean.setTell(rs.getString("tell"));
    408. 				bean.setEmail(rs.getString("email"));
    409. 				bean.setMotto(rs.getString("motto"));
    410. 				bean.setIntroduce(rs.getString("introduce"));
    411. 				bean.setGraduate_school(rs.getString("graduate_school"));
    412. 				bean.setSpecialty(rs.getString("specialty"));
    413. 				bean.setEducation(rs.getString("education"));
    414. 				bean.setAddress(rs.getString("address"));
    415. 				bean.setAuthentication(rs.getString("authentication"));
    416. 				bean.setExperience(rs.getString("experience"));
    417. 				bean.setMoney(rs.getString("money"));
    418. 				bean.setTeach_time(rs.getString("teach_time"));
    419. 				bean.setSubject(rs.getString("subject"));//得到所查询的科目
    420. 				bean.setArea(rs.getString("area"));//得到授课区域
    421. 				bean.setCreate_time(rs.getString("create_time"));
    422. 				bean.setImageC(rs.getString("imageC"));
    423. 				bean.setImageE(rs.getString("imageE"));
    424. 				//list.add(bean);
    425. 			}
    426. 		}
    427. 		catch (SQLException e) {
    428. 			// TODO Auto-generated catch block
    429. 			e.printStackTrace();
    430. 		}finally{
    431. 			this.close();
    432. 		}
    433. 		/*
    434. 		 * 20167-12添加end
    435. 		 * 
    436. 		 * */
    437. 		
    438. 		return bean;
    439. 	}
    440. 	
    441. 	//更新教员信息
    442. 	public boolean UpdateTeacher(String pid,String username,String sex,String age,String nation,String email,String motto,String introduce,String graduate_school,String specialty,String education,String experience,String tell){
    443. 		boolean tt=false;
    444. 		conn=Conn.getConnect();
    445. 		String sql = "update teacher set pid='"+pid+"',t_name='"+username+"',sex='"+sex+"',age='"+age+"',nationality='"+nation+"',email='"+email+"',motto='"+motto+"',introduce='"+introduce+"',graduate_school='"+graduate_school+"',specialty='"+specialty+"',education='"+education+"',experience='"+experience+"'  where tell='"+tell+"'";  
    446.         //String sql="update teacher set pid='"+pid+"'where id=1";
    447. 		try {
    448. 			ps=conn.prepareStatement(sql);
    449. 			int i=ps.executeUpdate();
    450. 			if(i>0){
    451. 				tt=true;
    452. 			}
    453. 		} catch (SQLException e) {
    454. 			// TODO Auto-generated catch block
    455. 			e.printStackTrace();
    456. 		}
    457. 		return tt;
    458. 	}
    459. 	
    460. 	public List Select(String tell){
    461. 	    	List teacher = new ArrayList();// 利用ArrayList类实例化List集合  
    462. 			conn=Conn.getConnect();
    463. 			System.out.println("查询个人信息-------------");
    464. 			String sql = "select * from teacher where tell='"+tell+"'";
    465. 			//System.out.println("21212");
    466. 	        try {
    467. 				ps=conn.prepareStatement(sql);
    468. 				rs=ps.executeQuery();
    469. 				//System.out.println("fsdfsd");
    470. 				if(rs.next()){
    471. 					String username=rs.getString("t_name");
    472. 					String pid=rs.getString("pid");
    473. 					String sex=rs.getString("sex");
    474. 					String age=rs.getString("age");
    475. 					String nation=rs.getString("nationality");
    476. 					String email=rs.getString("email");
    477. 					String motto=rs.getString("motto");
    478. 					String introduce=rs.getString("introduce");
    479. 					String graduate_school=rs.getString("graduate_school");
    480. 					String specialty=rs.getString("specialty");
    481. 					String education=rs.getString("education");
    482. 					String experience=rs.getString("experience");
    483. 					teacher.add(username);
    484. 					teacher.add(pid);
    485. 					teacher.add(age);
    486. 					teacher.add(sex);
    487. 					teacher.add(nation);
    488. 					teacher.add(email);
    489. 					teacher.add(motto);
    490. 					teacher.add(introduce);
    491. 					teacher.add(graduate_school);
    492. 					teacher.add(specialty);
    493. 					teacher.add(education);
    494. 					teacher.add(experience);
    495. 					}
    496. 	        }catch (SQLException e) {
    497. 				// TODO Auto-generated catch block
    498. 				e.printStackTrace();
    499. 			}
    500. 			return teacher;
    501. 	    }
    502. 	public boolean SetTimeMoney(String teach_time,String money,String tell){
    503. 			boolean tt=false;
    504. 			conn=Conn.getConnect();
    505. 			String sql = "update teacher set money='"+money+"',teach_time='"+teach_time+"' where tell='"+tell+"'";  
    506. 	        //String sql="update teacher set pid='"+pid+"'where id=1";
    507. 			try {
    508. 				ps=conn.prepareStatement(sql);
    509. 				int i=ps.executeUpdate();
    510. 				if(i>0){
    511. 					tt=true;
    512. 					System.out.print(tt);
    513. 				}
    514. 			} catch (SQLException e) {
    515. 				// TODO Auto-generated catch block
    516. 				e.printStackTrace();
    517. 			}
    518. 			return tt;
    519. 		}
    520.  
    521. 	//查询订单信息
    522. 	public ArrayList order(String tell,String role){
    523. 	   try {
    524. 	    	conn=Conn.getConnect();
    525. 	    	ArrayList order=new ArrayList();
    526. 	    	String sql="";
    527. 	    	if(role.equals("教员")){
    528. 	    		sql="select id,s_tell,subject,Rtime,address,method,money,remark,s_name from reservation where t_tell='"+tell+"'";
    529. 	    		ps=conn.prepareStatement(sql);
    530. 				rs=ps.executeQuery();
    531. 				while(rs.next()){
    532. 					OrderBean ob=new OrderBean();
    533. 					ob.setId(rs.getInt("id"));
    534. 					ob.setS_tell(rs.getString("s_tell"));
    535. 					ob.setSubject(rs.getString("subject"));
    536. 					ob.setRtime(rs.getString("Rtime"));
    537. 					ob.setAddress(rs.getString("address"));
    538. 					ob.setMethod(rs.getString("method"));
    539. 					ob.setMoney(rs.getString("money"));
    540. 					ob.setRemark(rs.getString("remark"));
    541. 					ob.setS_name(rs.getString("s_name"));
    542. 					System.out.println(ob);
    543. 					order.add(ob);
    544. 				}
    545. 				return order;
    546. 	    	}
    547. 	    	if(role.equals("学员")){
    548. 	    		sql="select id,t_tell,subject,Rtime,address,method,money,remark,t_name from reservation where s_tell='"+tell+"'";
    549. 	    		ps=conn.prepareStatement(sql);
    550. 				rs=ps.executeQuery();
    551. 				while(rs.next()){
    552. 					OrderBean ob=new OrderBean();
    553. 					ob.setId(rs.getInt("id"));
    554. 					ob.setT_tell(rs.getString("t_tell"));
    555. 					ob.setSubject(rs.getString("subject"));
    556. 					ob.setRtime(rs.getString("Rtime"));
    557. 					ob.setAddress(rs.getString("address"));
    558. 					ob.setMethod(rs.getString("method"));
    559. 					ob.setMoney(rs.getString("money"));
    560. 					ob.setRemark(rs.getString("remark"));
    561. 					ob.setT_name(rs.getString("t_name"));
    562. 					order.add(ob);
    563. 				}
    564. 				return order;
    565. 	    	}
    566. 				
    567. 			}
    568. 			catch (SQLException e) {
    569. 				// TODO Auto-generated catch block
    570. 				e.printStackTrace();
    571. 			}finally{
    572. 				this.close();
    573. 			}
    574. 	    	return null;
    575. 	    }
    576. 	    
    577. 	public boolean au_teacher(String u_id,String flag){//教员认证
    578. 		boolean tt=false;
    579. 		conn=Conn.getConnect();
    580. 		String sql="update "+flag+" set authentication='1',create_time=NOW() where u_id='"+u_id+"'";
    581. 		try {
    582. 			ps=conn.prepareStatement(sql);
    583. 			int i=ps.executeUpdate();
    584. 			if(i>0){
    585. 				tt=true;
    586. 			}
    587. 		}
    588. 		catch (SQLException e) {
    589. 			// TODO Auto-generated catch block
    590. 			e.printStackTrace();
    591. 		}
    592. 		return tt;
    593. 	}
    594. 	
    595. 	public boolean dell_teacher(String u_id){//删除教员
    596. 		boolean tt=false;
    597. 		conn=Conn.getConnect();
    598. 		String sql="delete from user where id="+u_id;
    599. 		try {
    600. 			ps=conn.prepareStatement(sql);
    601. 			int i=ps.executeUpdate();
    602. 			if(i>0){
    603. 				tt=true;
    604. 			}
    605. 		}
    606. 		catch (SQLException e) {
    607. 			// TODO Auto-generated catch block
    608. 			e.printStackTrace();
    609. 		}
    610. 		return tt;
    611. 	}
    612. 	    
    613. 	    
    614. 	    
    615. 	    
    616. 	    
    617. 	    
    618. 	    
    619. 	    
    620. 	    
    621. 	  //关闭资源
    622. 	  		public void close(){
    623. 	  			try {
    624. 	  				if(rs!=null){
    625. 	  					rs.close();
    626. 	  					rs=null;
    627. 	  				}
    628. 	  				if(ps!=null){
    629. 	  					ps.close();
    630. 	  					ps=null;
    631. 	  				}
    632. 	  				if(conn!=null){
    633. 	  					conn.close();
    634. 	  					conn=null;
    635. 	  				}
    636. 	  			} catch (SQLException e) {
    637. 	  				// TODO Auto-generated catch block
    638. 	  				e.printStackTrace();
    639. 	  			}
    640. 	  		}
    641.  
    642. }
    643.

    如果也想学习本系统，下面领取。关注并回复：087jsp

  • 相关阅读:
    机器视觉面试-查漏补缺
    人工智能框架实战精讲：Keras项目-英文语料的文本分类实战与调参优化
    域名抢注“卷”到了表情包？ENS逆势上涨的新推力
    合成孔径雷达地面运动目标检测技术研究——基于概率图（Matlab代码实现）
    CPK分析工具页面设计源码
    Java获取某天、某月或某年的开始结束日期或开始结束时间戳
    Go-函数作为参数传递
    vue3中使用setup语法糖使用
    分布式唯一ID
    【C/C++】size_t详解
  • 原文地址：https://blog.csdn.net/hanyunlong1989/article/details/126965234