连接语句结果集rsjavaweb大作业.pdfVIP

/body

Ok.jsp

body

table

%

Connectioncon;

Statementsmt;

ResultSetrs;

Stringurljdbc:sqlserver://:1433;databaseName=test;

Stringusersa;

Stringpassword123456;

Stringsqlselect*fromsoftuser;

DriverManager.registerDriver(newSQLServerDriver());

con=DriverManager.getConnection(url,user,password);

smt=con.createStatement();

rs=smt.executeQuery(sql);

while(rs.next())

{

//out.print(rs.getString(1));

//out.print(br);

%

tr

tdahrefxx.jsp?uname%rs.getString(1)%%rs.getString(1)%/a

tdtdahrefxg.jsp?uname%rs.getString(1)%修改/atd

tdahrefdel.jsp?uname%rs.getString(1)%删除/atd

/tr

%

}

%

/table

ahrefaddU.jsp新增用户/a

/body

xx.jsp

body

%

Stringuname=request.getParameter(uname);

Connectioncon;

Statementsmt;

ResultSetrs;

Stringurljdbc:sqlserver://:1433;databaseName=test;

Stringusersa;

Stringpassword123456;

Stringsqlselect*fromsoftuserwhereusername=+uname+;

DriverManager.registerDriver(newSQLServerDriver());

con=DriverManager.getConnection(url,user,password);

smt=con.createStatement();

rs=smt.executeQuery(sql);

if(rs.next())

{

%

用户名：%rs.getString(1)%

：%rs.getString(2)%

%

}

%

ahrefok.jsp返回/a

/body

Xg.jsp

body

%

Stringuname=request.getParameter(uname);

Connectioncon;

Statementsmt;

ResultSetrs;

Stringurljdbc:sqlserver://:1433;databaseName=test;

Stringusersa;

Stringpassword123456;

Stringsqlselect*fromsoftuserwhereusername=+uname+;

DriverManager.registerDriver(newSQLServerDriver());

con=DriverManager.getConnection(url,user,password);

s