⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 inquire.java

📁 可以让初学者有一个感性的认识
💻 JAVA
字号:
🔍 
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class Inquire extends HttpServlet
{
	public void init(ServletConfig config) throws ServletException
	{
		super.init(config);
	}


	public void doPost(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException
	{
		PrintWriter out=response.getWriter();
		response.setContentType("text/html;charset=GB2312");
		out.println("<HTML><BODY>");
		String name=request.getParameter("name");
		byte a[]=name.getBytes("ISO-8859-1");
		name=new String(a);
		String number="",xingming="";
		Connection con=null;
		Statement sql=null;
		ResultSet rs=null;
		int math,english,physics;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){}
		try
		{
			con=DriverManager.getConnection("jdbc:odbc:sun","","");
			sql=con.createStatement();
			String condition="SELECT * FROM students WHERE 姓名="+"'"+name+"'";
			rs=sql.executeQuery(condition);
			out.print("<Table Border>");
			out.print("<TR>");
				out.print("<TH width=100>"+"Number");
				out.print("<TH width=100>"+"Name");
				out.print("<TH width=50>" +"Math");
				out.print("<TH width=50>" +"English");
				out.print("<TH width=50>" +"Phsics");
			out.print("</TR>");
			while(rs.next())
			{
				out.print("<TR>");
					number=rs.getString(1);
					out.print("<TD>"+number+"</TD>");
					xingming=rs.getString(2);
					out.print("<TD>"+xingming+"</TD>");
					math=rs.getInt("数学成绩");
					out.print("<TD>"+math+"</TD>");
					english=rs.getInt("英语成绩");
					out.print("<TD>"+english+"</TD>");
					physics=rs.getInt("物理成绩");
					out.print("<TD>"+physics+"</TD>");
				out.print("</TR>");
			}
			out.print("</Table>");
			con.close();
		}catch(SQLException e1){}
		out.println("</BODY></HTML>");
	}

	public void doGet(HttpServletRequest request,HttpServletResponse response) throws IOException,ServletException
	{
		PrintWriter out=response.getWriter();
		response.setContentType("text/html;charset=GB2312");
		out.println("<HTML><BODY>");
		String englishmax=request.getParameter("englishmax");
		if(englishmax==null) englishmax ="100";
		String englishmin=request.getParameter("englishmin");
		if(englishmin ==null) englishmin ="0";
		String mathmax=request.getParameter("mathmax");
		if(mathmax ==null) mathmax ="100";
		String mathmin=request.getParameter("mathmin");
		if(mathmin ==null) mathmin ="0";
		String number,xingming;
		Connection con=null;
		Statement sql=null;
		ResultSet rs=null;
		int math,english,physics;
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}catch(ClassNotFoundException e){}
		try
		{
			con=DriverManager.getConnection("jdbc:odbc:sun","","");
			sql=con.createStatement();
			String eCondition="英语成绩<="+englishmax+" AND "+"英语成绩>="+englishmin;
			String mCondition="数学成绩<="+mathmax+" AND "+" 数学成绩>="+mathmin;
			String condition="SELECT * FROM students WHERE "+mCondition+"and "+eCondition;
			rs=sql.executeQuery(condition);
			out.print("<Table Border>");
			out.print("<TR>");
				out.print("<TH width=100>"+"学号");
				out.print("<TH width=100>"+"姓名");
				out.print("<TH width=50>" +"数学成绩");
				out.print("<TH width=50>" +"英语成绩");
				out.print("<TH width=50>" +"物理成绩");
			out.print("</TR>");
			while(rs.next())
			{
				out.print("<TR>");
					number=rs.getString(1);
					out.print("<TD>"+number+"</TD>");
					xingming=rs.getString(2);
					out.print("<TD>"+xingming+"</TD>");
					math=rs.getInt("数学成绩");
					out.print("<TD>"+math+"</TD>");
					english=rs.getInt("英语成绩");
					out.print("<TD>"+english+"</TD>");
					physics=rs.getInt("物理成绩");
					out.print("<TD>"+physics+"</TD>");
				out.print("</TR>");
			}
			out.print("</Table>");
			con.close();
		}catch(SQLException e1){}
		out.println("</BODY></HTML>");
	}

}

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -