交大JSP大题题程序.docx

1、交大JSP大题题程序Circle.javapackage tom.jiafeiimport java.io.*;public class Circle int radius; public Circle() /声明构造方法 radius=1; public int getRadius() return radius; public void setRadius(int newRadius) radius=newRadius; public double circleArea() return Math.PI*radius*radius; public double circlLength()

2、return 2.0*Math.PI*radius; bean2.jsp 圆的半径是： 修改后的圆的半径是：bean1.jsp NewCircle.javapackage tom.jiafei;import java.io.*;public class NewCircle double radius=1,circleArea,circleLength; public double getRadius() return radius; public void setRadius(double newRadius) radius=newRadius; public double getCircle

3、Area() circleArea=Math.PI*radius*radius; return circleArea; public double getCircleLength() circleLength=2.0*Math.PI*radius; return circleLength; appbean.jsp 圆的初始半径是： 修改后的圆的半径是：beanGetProperty.jsp 圆的半径是：圆的面积是：圆的周长是：Triangle.javapackage red.star;public class Triangle double sideA=-1,sideB=-1,sideC=-1

4、, area=-1; boolean triangle; public void setSideA(double a) sideA=a; public double getSideA() return sideA; public void setSideB(double b) sideB=b; public double getSideB() return sideB; public void setSideC(double c) sideC=c; public double getSideC() return sideC; public double getArea() double p=(

5、sideA+sideB+sideC)/2.0; if(triangle) area=Math.sqrt(p*(p-sideA)*(p-sideB)*(p-sideC); return area; public boolean isTriangle() if(sideAsideB+sideC&sideBsideA+sideC&sideCsideA+sideB) triangle=true; else triangle=false; return triangle; triangle.jsp 输入三角形三边： 边A: （注; sideA,sideB,sideC 应与java文件中的对象同名 才可以

6、在setProperty中的property=“*”） 边B: 边C: 三角形的三边是： 边A：, 边B：, 边C：.这三个边能构成一个三角形吗？面积是： ComputerBean.javapackage red.star;public class ComputerBean double numberOne,numberTwo,result; String operator=+; public void setNumberOne(double n) numberOne=n; public double getNumberOne() return numberOne; public void s

7、etNumberTwo(double n) numberTwo=n; public double getNumberTwo() return numberTwo; public void setOperator(String s) operator=s.trim(); public String getOperator() return operator; public double getResult() if(operator.equals(+) result=numberOne+numberTwo; else if(operator.equals(-) result=numberOne-

8、numberTwo; else if(operator.equals(*) result=numberOne*numberTwo; else if(operator.equals(/) result=numberOne/numberTwo; return result; computer.jsp Input type=text name=numberOne value= size=6 + - * / Input type=text name=numberTwo value= size=6 = showByJdbcOdbc.jsp 3000);/执行查询语句 out.print(); out.p

9、rint(); out.print(+雇员号); out.print(+姓名); out.print(+出生日期); out.print(+薪水); out.print(); while(rs.next() out.print(); out.print(+rs.getString(1)+); （假如题中有表） out.print(+rs.getString(2)+); out.print(+rs.getDate(birthday)+); out.print(+rs.getFloat(salary)+); out.print() ; out.print(); con.close(); catch

10、(SQLException e) out.print(e); %showBySQLDriver.jsp 3000);/执行查询语句 out.print(); out.print(); out.print(+雇员号); out.print(+姓名); out.print(+出生日期); out.print(+薪水); out.print(); while(rs.next() out.print(); out.print(+rs.getString(1)+); out.print(+rs.getString(2)+); out.print(+rs.getDate(birthday)+); out.

11、print(+rs.getFloat(salary)+); out.print() ; out.print(); con.close(); catch(SQLException e) out.print(e); %QueryBean.javapackage database.operation;import java.sql.*;public class QueryBean String databaseName=; /数据库名 String tableName=; /表名 String user= ; /用户 String secret= ; /密码 StringBuffer queryRe

12、sult; /查询结果 public QueryBean() queryResult=new StringBuffer(); try Class.forName(com.microsoft.sqlserver.jdbc.SQLServerDriver); catch(Exception e) public void setDatabaseName(String s) databaseName=s.trim(); queryResult=new StringBuffer(); public String getDatabaseName() return databaseName; public

13、void setTableName(String s) tableName=s.trim(); queryResult=new StringBuffer(); public String getTableName() return tableName; public void setSecret(String s) secret=s.trim(); queryResult=new StringBuffer(); public String getSecret() return secret; public void setUser(String s) user=s.trim(); queryR

14、esult=new StringBuffer(); public String getUser() return user; public StringBuffer getQueryResult() Connection con; Statement sql; ResultSet rs; try queryResult.append(); String uri= jdbc:sqlserver:/127.0.0.1:1433;DatabaseName=+databaseName; String id=user; String password=secret; con=DriverManager.

15、getConnection(uri,id,password); DatabaseMetaData metadata=con.getMetaData(); ResultSet rs1=metadata.getColumns(null,null,tableName,null); int 字段个数=0; queryResult.append(); while(rs1.next() 字段个数+; String clumnName=rs1.getString(4); queryResult.append(+clumnName+); queryResult.append(); sql=con.create

16、Statement(); rs=sql.executeQuery(SELECT * FROM +tableName); while(rs.next() queryResult.append(); for(int k=1;k=字段个数;k+) queryResult.append(+rs.getString(k)+); queryResult.append(); queryResult.append(); con.close(); catch(SQLException e) queryResult.append(请输入正确的用户名和密码); return queryResult; inquire.jsp 输入数据库名: 输入表的名字: 输入用户名： 输入密码： Input type=passwor