jsp 按照学号查找学生_jsp+mysql添加查询代码，并把查询结果返回当前页面，可以按学号，姓名或成绩查询…

表的结构：createtablescore(numvarchar(12)primarykey,namevarchar(20),scoredecimal(5,2));JSP代码：(在里面插入查询代码)

表的结构：

create table score

(num varchar(12) primary key,

name varchar(20),

score decimal(5,2)

);

JSP代码：(在里面插入查询代码)

/p>

“http://www.w3.org/TR/html4/loose.dtd”>

JSP Page

try{

Class.forName(“com.microsoft.jdbc.sqlserver.SQLServerDriver”);

Connection con=DriverManager.getConnection(“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=student”, “ting”, “111”);

Statement st=con.createStatement();

ResultSet rs=st.executeQuery(“select * from score “);

String num,name;

float score;

if (rs!=null)

{

while (rs.next()){

num=rs.getString(“num”);

name=rs.getString(“name”);

score=rs.getFloat(“score”);

%>

}

rs.close();

}

st.close();

con.close();

}

catch(Exception e)

{

throw e;

}

%>

展开