交大JSP大题题程序.docx

上传人:b****4 文档编号:5540747 上传时间:2023-05-08 格式:DOCX 页数:14 大小:17.55KB
下载 相关 举报
交大JSP大题题程序.docx_第1页
第1页 / 共14页
交大JSP大题题程序.docx_第2页
第2页 / 共14页
交大JSP大题题程序.docx_第3页
第3页 / 共14页
交大JSP大题题程序.docx_第4页
第4页 / 共14页
交大JSP大题题程序.docx_第5页
第5页 / 共14页
交大JSP大题题程序.docx_第6页
第6页 / 共14页
交大JSP大题题程序.docx_第7页
第7页 / 共14页
交大JSP大题题程序.docx_第8页
第8页 / 共14页
交大JSP大题题程序.docx_第9页
第9页 / 共14页
交大JSP大题题程序.docx_第10页
第10页 / 共14页
交大JSP大题题程序.docx_第11页
第11页 / 共14页
交大JSP大题题程序.docx_第12页
第12页 / 共14页
交大JSP大题题程序.docx_第13页
第13页 / 共14页
交大JSP大题题程序.docx_第14页
第14页 / 共14页
亲,该文档总共14页,全部预览完了,如果喜欢就下载吧!
下载资源
资源描述

交大JSP大题题程序.docx

《交大JSP大题题程序.docx》由会员分享,可在线阅读,更多相关《交大JSP大题题程序.docx(14页珍藏版)》请在冰点文库上搜索。

交大JSP大题题程序.docx

交大JSP大题题程序

Circle.java

packagetom.jiafei

importjava.io.*;

publicclassCircle

{intradius;

publicCircle()//声明构造方法

{radius=1;}

publicintgetRadius()

{returnradius;}

publicvoidsetRadius(intnewRadius)

{radius=newRadius;}

publicdoublecircleArea()

{returnMath.PI*radius*radius;}

publicdoublecirclLength()

{return2.0*Math.PI*radius;}

}

bean2.jsp

<%@pagecontentType="text/html;charset=GB2312"%>

<%@pageimport="tom.jiafei.Circle"%>

useBeanid="girl"class="tom.jiafei.Circle"scope="session"/>

圆的半径是:

<%=girl.getRadius()%>

<%girl.setRadius(400);%>

修改后的圆的半径是:

<%=girl.getRadius()%>


bean1.jsp

NewCircle.java

packagetom.jiafei;

importjava.io.*;

publicclassNewCircle

{doubleradius=1,circleArea,circleLength;

publicdoublegetRadius()

{returnradius;}

publicvoidsetRadius(doublenewRadius)

{radius=newRadius;}

publicdoublegetCircleArea()

{circleArea=Math.PI*radius*radius;

returncircleArea;

}

publicdoublegetCircleLength()

{circleLength=2.0*Math.PI*radius;

returncircleLength;

}

}

appbean.jsp

<%@pagecontentType="text/html;charset=GB2312"%>

<%@pageimport="tom.jiafei.*"%>

useBeanid="girl"class="tom.jiafei.Circle"scope="application">

useBean>

圆的初始半径是:

<%=girl.getRadius()%>

<%girl.setRadius(1000);%>

修改后的圆的半径是:

<%=girl.getRadius()%>

beanGetProperty.jsp

<%@pagecontentType="text/html;charset=GB2312"%>

<%@pageimport="tom.jiafei.NewCircle"%>

useBeanid="apple"class="tom.jiafei.NewCircle"scope="request"/>

<%apple.setRadius(100);%>

圆的半径是:

getPropertyname="apple"property="radius"/>


圆的面积是:

getPropertyname="apple"property="circleArea"/>


圆的周长是:

getPropertyname="apple"property="circleLength"/>

Triangle.java

packagered.star;

publicclassTriangle

{doublesideA=-1,sideB=-1,sideC=-1,area=-1;

booleantriangle;

publicvoidsetSideA(doublea)

{sideA=a;}

publicdoublegetSideA()

{returnsideA;}

publicvoidsetSideB(doubleb)

{sideB=b;}

publicdoublegetSideB()

{returnsideB;}

publicvoidsetSideC(doublec)

{sideC=c;}

publicdoublegetSideC()

{returnsideC;}

publicdoublegetArea()

{doublep=(sideA+sideB+sideC)/2.0;

if(triangle)

area=Math.sqrt(p*(p-sideA)*(p-sideB)*(p-sideC));

returnarea;}

publicbooleanisTriangle()

{if(sideA

triangle=true;

elsetriangle=false;

returntriangle;}

}

 

triangle.jsp

<%@pagecontentType="text/html;Charset=GB2312"%>

<%@pageimport="red.star.Triangle"%>

useBeanid="tri"class="red.star.Triangle"scope="page"/>

输入三角形三边:

边A:

(注;sideA,sideB,sideC应与java文件中的对象同名才可以在setProperty中的property=“*”)

边B:

边C:

setPropertyname="tri"property="*"/>

三角形的三边是:

边A:

getPropertyname="tri"property="sideA"/>,

边B:

getPropertyname="tri"property="sideB"/>,

边C:

getPropertyname="tri"property="sideC"/>.


这三个边能构成一个三角形吗?

getPropertyname="tri"property="triangle"/>


面积是:

getPropertyname="tri"property="area"/>

ComputerBean.java

packagered.star;

publicclassComputerBean

{doublenumberOne,numberTwo,result;

Stringoperator="+";

publicvoidsetNumberOne(doublen)

{numberOne=n;}

publicdoublegetNumberOne()

{returnnumberOne;}

publicvoidsetNumberTwo(doublen)

{numberTwo=n;}

publicdoublegetNumberTwo()

{returnnumberTwo;}

publicvoidsetOperator(Strings)

{operator=s.trim();}

publicStringgetOperator()

{returnoperator;}

publicdoublegetResult()

{if(operator.equals("+"))

{result=numberOne+numberTwo;}

elseif(operator.equals("-"))

{result=numberOne-numberTwo;}

elseif(operator.equals("*"))

{result=numberOne*numberTwo;}

elseif(operator.equals("/"))

{result=numberOne/numberTwo;}

returnresult;}

}

computer.jsp

<%@pagecontentType="text/html;Charset=GB2312"%>

<%@pageimport="red.star.*"%>

useBeanid="computer"class="red.star.ComputerBean"scope="session"/>

setPropertyname="computer"property="*"/>

value=

getPropertyname="computer"property="numberOne"/>size=6>

+

-

*

/

value=

getPropertyname="computer"property="numberTwo"/>size=6>

=

getPropertyname="computer"property="result"/>


showByJdbcOdbc.jsp

<%@pagecontentType="text/html;charset=GB2312"%>

<%@pageimport="java.sql.*"%>

<%Connectioncon;

Statementsql;

ResultSetrs;

try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

}

catch(ClassNotFoundExceptione)

{out.print(e);

}

try{con=DriverManager.getConnection("jdbc:

odbc:

mymoon","sa","sa");//连接数据库

sql=con.createStatement();

rs=sql.executeQuery("SELECT*FROMemployeeWHEREsalary>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.print(""+rs.getFloat("salary")+"");

out.print("");

}

out.print("");

con.close();

}

catch(SQLExceptione)

{out.print(e);

}

%>

showBySQLDriver.jsp

<%@pagecontentType="text/html;charset=GB2312"%>

<%@pageimport="java.sql.*"%>

<%Connectioncon;

Statementsql;

ResultSetrs;

try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

}

catch(Exceptione)

{out.print(e);

}

try{Stringuri="jdbc:

sqlserver:

//127.0.0.1:

1433;DatabaseName=factory";

Stringuser="sa";//设置用户名

Stringpassword="sa";//设置密码

con=DriverManager.getConnection(uri,user,password);//连接数据库

sql=con.createStatement();

rs=sql.executeQuery("SELECT*FROMemployeeWHEREsalary>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.print(""+rs.getFloat("salary")+"");

out.print("");

}

out.print("");

con.close();

}

catch(SQLExceptione)

{out.print(e);

}

%>

QueryBean.java

packagedatabase.operation;

importjava.sql.*;

publicclassQueryBean

{StringdatabaseName="";//数据库名

StringtableName="";//表名

Stringuser="";//用户

Stringsecret="";//密码

StringBufferqueryResult;//查询结果

publicQueryBean()

{queryResult=newStringBuffer();

try{Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

}

catch(Exceptione){}

}

publicvoidsetDatabaseName(Strings)

{databaseName=s.trim();

queryResult=newStringBuffer();

}

publicStringgetDatabaseName()

{returndatabaseName;

}

publicvoidsetTableName(Strings)

{tableName=s.trim();

queryResult=newStringBuffer();

}

publicStringgetTableName()

{returntableName;

}

publicvoidsetSecret(Strings)

{secret=s.trim();

queryResult=newStringBuffer();

}

publicStringgetSecret()

{returnsecret;

}

publicvoidsetUser(Strings)

{user=s.trim();

queryResult=newStringBuffer();

}

publicStringgetUser()

{returnuser;

}

publicStringBuffergetQueryResult()

{Connectioncon;

Statementsql;

ResultSetrs;

try{queryResult.append("");

Stringuri="jdbc:

sqlserver:

//127.0.0.1:

1433;DatabaseName="+databaseName;

Stringid=user;

Stringpassword=secret;

con=DriverManager.getConnection(uri,id,password);

DatabaseMetaDatametadata=con.getMetaData();

ResultSetrs1=metadata.getColumns(null,null,tableName,null);

int字段个数=0;

queryResult.append("");

while(rs1.next())

{字段个数++;

StringclumnName=rs1.getString(4);

queryResult.append(""+clumnName+"");

}

queryResult.append("");

sql=con.createStatement();

rs=sql.executeQuery("SELECT*FROM"+tableName);

while(rs.next())

{queryResult.append("");

for(intk=1;k<=字段个数;k++)

{queryResult.append(""+rs.getString(k)+"");

}

queryResult.append("");

}

queryResult.append("");

con.close();

}

catch(SQLExceptione)

{queryResult.append("请输入正确的用户名和密码");

}

returnqueryResult;

}

}

inquire.jsp

<%@pagecontentType="text/html;charset=GB2312"%>

<%@pageimport="database.operation.QueryBean"%>

useBeanid="base"class="database.operation.QueryBean"scope="session"/>

setPropertyname="base"property="*"/>

输入数据库名:

输入表的名字:


输入用户名:

输入密码:

展开阅读全文
相关资源
猜你喜欢
相关搜索
资源标签

当前位置:首页 > 医药卫生 > 基础医学

copyright@ 2008-2023 冰点文库 网站版权所有

经营许可证编号:鄂ICP备19020893号-2