wxclass_1.java

java 学生成绩管理系统 基本功能： 录入 修改 删除 查询

import java.io.IOException;
import java.io.PrintWriter;
import java.io.UnsupportedEncodingException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class Wxclass_1 extends HttpServlet {

	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws IOException, ServletException {

		doPost(request, response);
	}

	public void doPost(HttpServletRequest request, HttpServletResponse response)
			throws IOException, ServletException {

		try {
			request.setCharacterEncoding("GB2312");
		} catch (UnsupportedEncodingException e) {
			e.printStackTrace();
		}
		String action = request.getParameter("action");
		if ("login".equals(action)) {

			doSelect(request, response);
		} else if ("clear".equals(action)) {
			doback(request, response);
		}
		else if("yes".equals(action)){
		 doInsert(request, response);}
		else if("OK".equals(action)){
			dochaxun(request, response);
		}
		else if("add".equals(action)){
			doadd(request, response);
		}
		else if("delete".equals(action)){
			dodelete(request, response);
		}
		else {
			response.sendError(HttpServletResponse.SC_NOT_IMPLEMENTED);

		}

	}

	private void doInsert(HttpServletRequest rq, HttpServletResponse rp)
			throws IOException, ServletException {

		rp.setContentType("text/html; charset=gb2312");
		PrintWriter out = rp.getWriter();
		String newnm = rq.getParameter("textfield3").trim();
		String newtj = rq.getParameter("textfield4").trim();
		System.out.println(newnm);
		try {
			DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
			Connection con = DriverManager.getConnection("jdbc:odbc:wxdb1");
			Statement stmt = con.createStatement();
			String s1;
			s1 = "insert into wxbiao1 values('" + newnm + "','" + newtj + "')";
			out.println("注册成功");
			
			out.println("<div align="
					+ "center"
					+ " ><a href="
					+ "http://localhost:8080/wxjava_1/Untitled-2.jsp"
					+ ">返回主页</a></div>");
			stmt.executeUpdate(s1);
			con.close();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

	private void doSelect(HttpServletRequest rq, HttpServletResponse rp)
			throws IOException, ServletException {

		rp.setContentType("text/html; charset=gb2312");
		PrintWriter out = rp.getWriter();
		String nm = rq.getParameter("textfield").trim();
		String tj = rq.getParameter("textfield2").trim();
		// System.out.println(nm);
		try {
			DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
			Connection con = DriverManager.getConnection("jdbc:odbc:wxdb1");
			Statement stmt = con.createStatement();
			// String name = nm.trim();
			String s;
			s = "select * from  wxbiao1 where id= '" + nm + "' ";
			ResultSet rset = stmt.executeQuery(s);
			if (rset.next()) {
				{
					String r1 = rset.getString(1);
					String r2 = rset.getString(2);
					// System.out.println(r1);
					if (r1.equals(nm) && r2.equals(tj)) {
						out.println("<div align="
								+ "center"
								+ " ><a href="
								+ "http://localhost:8080/wxjava_1/student.jsp"
								+ ">点此进入学生成绩管理系统</a></div>");
					}

					else {
						out.println("id or password is  error");

						// out.println( rset.getString(1));

						out
								.println("<div align="
										+ "center"
										+ " ><a href="
										+ "http://localhost:8080/wxjava_1/Untitled-2.jsp"
										+ ">返回主页</a></div>");
					}
				}
			} else {
				out.println("id or password is  error");
				out.println("<div align=" + "center" + " ><a href="
						+ "http://localhost:8080/wxjava_1/Untitled-2.jsp"
						+ ">返回主页</a></div>");
			}
			rset.close();
			stmt.close();
		}

		catch (Exception e) {
		}
	}
	private void dochaxun(HttpServletRequest rq, HttpServletResponse rp)
	throws IOException, ServletException {

rp.setContentType("text/html; charset=gb2312");
PrintWriter out = rp.getWriter();
String cx = rq.getParameter("chaxun").trim();
String se = rq.getParameter("select").trim();
try {
	DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
	Connection con = DriverManager.getConnection("jdbc:odbc:student");
	Statement stmt = con.createStatement();
	String s2;
	s2 = "select * from  student where "+se+"= '" + cx + "' ";
	ResultSet rset = stmt.executeQuery(s2);
		if(rset.next()){
			String r1 = rset.getString(1);
			String r2 = rset.getString(2);
			String r3 = rset.getString(3);
			String r4 = rset.getString(4);
			String r5 = rset.getString(5);
			if(r1.equals(cx)||r2.equals(cx)){
				out.println("姓名:"+r1);
				out.println("学号"+r2);
				out.println("高数"+r3);
				out.println("物理"+r4);
				out.println("英语"+r5);
			}
			
			
		}
		else
			out.println("数据库中没有这项记录");

		}catch (Exception e) {
		}out.println("<div align="
				+ "center"
				+ " ><a href="
				+ "http://localhost:8080/wxjava_1/student.jsp"
				+ ">返回学生成绩管理系统</a></div>");
		
	}
	private void doadd(HttpServletRequest rq, HttpServletResponse rp)
	throws IOException, ServletException {

		rp.setContentType("text/html; charset=gb2312");
		PrintWriter out = rp.getWriter();
		String na= rq.getParameter("name").trim();
		String nu= rq.getParameter("number").trim();
		String gs= rq.getParameter("gaoshu").trim();
		String wl= rq.getParameter("wuli").trim();
		String en= rq.getParameter("english").trim();
		try{
			DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
			Connection con = DriverManager.getConnection("jdbc:odbc:student");
			Statement stmt = con.createStatement();
			String add;
			add="insert into student values('"+na+"','"+nu+"','"+gs+"','"+wl+"','"+en+"')";
			stmt.executeUpdate(add);
			out.println("数据已插入");
		}catch (Exception e){	
		}
		out.println("<div align="
				+ "center"
				+ " ><a href="
				+ "http://localhost:8080/wxjava_1/student.jsp"
				+ ">返回学生成绩管理系统</a></div>");
	}
	private void dodelete(HttpServletRequest rq, HttpServletResponse rp)
	throws IOException, ServletException {

		rp.setContentType("text/html; charset=gb2312");
		PrintWriter out = rp.getWriter();
		String sc = rq.getParameter("shanchu").trim();
		String de = rq.getParameter("delete").trim();
		try{
			DriverManager.registerDriver(new sun.jdbc.odbc.JdbcOdbcDriver());
			Connection con = DriverManager.getConnection("jdbc:odbc:student");
			Statement stmt = con.createStatement();
			String del;
			del="delete * from student where "+sc+" = '"+de+"' ";
			stmt.executeUpdate(del);
			out.println("成功删除此项记录");
		}catch (Exception e){
			
		}out.println("<div align="
				+ "center"
				+ " ><a href="
				+ "http://localhost:8080/wxjava_1/student.jsp"
				+ ">返回学生成绩管理系统</a></div>");
		}
	private void doback(HttpServletRequest rq, HttpServletResponse rp)
	throws IOException, ServletException {
		rp.setContentType("text/html; charset=gb2312");
		PrintWriter out = rp.getWriter();
		out.println("<div align=" + "center" + " ><a href="
				+ "http://localhost:8080/wxjava_1/Untitled-2.jsp"
				+ ">返回主页</a></div>");
	}
}