<%@ page contentType="text/html;charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html";charset=gb2312">
<title>JSP杩炴帴鏁版嵁搴?lt;/title>
</head>
<body>
<%
String sql=request.getParameter("sqlid");
String mySqlDriver = "org.gjt.mm.mysql.Driver";
String url = "jdbc:mysql://localhost/mydatabase";
Connection conn;
Class.forName(mySqlDriver).newInstance();
conn = DriverManager.getConnection(url,"root","34497267");
if(conn==null){
System.out.println("get Conn Error");
}
Statement stmt=conn.createStatement();
ResultSet rs=null;
rs=stmt.executeQuery(sql);
while(rs.next())
{
String s1=rs.getString(1);
String s2=rs.getString(2);
String s3=rs.getString(3);
out.println(s1+" | "+s2+" | "+s3+"<br>");
}
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
鐜板湪鐨勯棶棰樻槸锛屾垜鍙鏀瑰彉sqlid浼犺繘鏉ョ殑SQL璇彞锛堝熀鏈拡瀵逛换浣昐QL璇彞锛夛紝閭ｄ箞杩欎釜椤甸潰鎵ц鐨勭粨鏋滆兘鎶婃煡鍒扮殑鏁版嵁浠ヨ〃鏍肩殑褰㈠紡鏄剧ず鍑烘潵锛屼笉绠℃垜鐨凷QL璇彞鏄€庝箞鏍风殑锛屼笉绠℃暟鎹簱涓殑鏁版嵁鏈夊灏戜釜灞炴€э紝鎴戝彧瑕佽兘鏈€鍚庡湪椤甸潰涓婃纭樉绀烘垜鏌ョ殑鏁版嵁鐨勮〃鏍兼樉绀恒€傛垜瑙夌殑涓昏鏄繖娈电殑闂锛?
while(rs.next())
{
String s1=rs.getString(1);
String s2=rs.getString(2);
String s3=rs.getString(3);
out.println(s1+" | "+s2+" | "+s3+"<br>");
}
涓嶇煡閬撴€庝箞鏀瑰ソ锛屽摢浣嶅ぇ鍝ユ湁娓呮鐨勶紵鍛婅瘔鎴戣阿璋紒
7 涓В鍐虫柟妗?/h2>
#1
缁欎釜浣犵被浼肩殑渚嬪瓙锛屼笉鐭ラ亾浣犳槸涓嶆槸杩欎釜鎰忔€?
test.jsp
<%@ page contentType="text/html;charset=utf-8"%>
<html>
<head>
<title>Test page</title>
</head>
<body>
<table border="1">
<%
for (int i = 0; i < 10; i++) {
String s1 = i + "a";
String s2 = i + "b";
String s3 = i + "c";
%>
<tr>
<td><%=s1%></td>
<td><%=s2%></td>
<td><%=s3%></td>
</tr>
<%
}
%>
</table>
</body>
</html>
#2
<table>
<tr>
<td>缂栧彿</td>
<td>鐢ㄦ埛鍚?lt;/td>
<td>鏂囩珷鍚?lt;/td>
<td>鍐呭</td>
<td>鍒犻櫎</td>
</tr>
<%
LiuYanming id = new LiuYanImpl();
List<LiuYan> list = id.selectAll();
Iterator it=list.iterator();
while(it.hasNext()){
LiuYan liuyans = (LiuYan)it.next();
%>
<tr>
<td><%=liuyans.getId() %></td>
<td><%=liuyans.getUsername()%></td>
<td><%=liuyans.getLname()%></td>
<td><%=liuyans.getLtextarea()%></td>
<td><a href="delete.do?id=<%=liuyans.getId()%>">鍒犻櫎</a></td>
</tr>
<%}%>
</table>
#3
灏辫杩欐牱鍐欏憖:
<html>
<head>
<title> Test page </title>
</head>
<body>
<table border="1">
<%
while(rs.next())
{
String s1=rs.getString(1);
String s2=rs.getString(2);
String s3=rs.getString(3);
out.println(s1+" 娄 "+s2+" 娄 "+s3+" <br> ");
%>
<tr>
<td> <%=s1%> </td>
<td> <%=s2%> </td>
<td> <%=s3%> </td>
</tr>
<%
}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>
浣犺嚜宸辫瘯璇曞惂,绁濅綘濂借繍鍝?..
#4
鎭?nbsp;璋㈣阿 鍑犱綅锛?
鎴戠湅浜嗕笅浣犱滑鐨?nbsp;缁堜簬鏈変簡鎯虫硶锛?
rs=stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
%>
<center>
<%
out.println("鏁版嵁搴撲负锛?+rsmd.getCatalogName(1));
%>
<table border>
<tr align=left>
<%
for(int i=1;i<numberOfColumns+1;i++){
%>
<th align=left><%=rsmd.getColumnName(i)%></th>
<br>
<%
}
%>
</tr>
<%
while(rs.next())
{
%>
<tr align=left>
<%
for(int i=1;i<numberOfColumns+1;i++){
%>
<td align=left><%=rs.getString(i)%></td>
<%
}
%>
</tr>
<%
}
%>
<%
rs.close();
#5
鏈€缁?nbsp;鍙互瀹屾暣鐨勪互琛ㄦ牸褰㈠紡鏄剧ず浜?nbsp;鍛靛懙 璋㈣阿浜嗗摝锛?
#6
鎴戜篃纰板埌杩囪繖鏍风殑闂锛岄《涓€涓?
#7
鎴戜篃鎯冲疄鐜拌繖涓敤.net鎬庝箞瀹炵幇鍟婏紝璇︾粏璇存槑涓€涓嬪惂 璋㈣阿浜?
#1
缁欎釜浣犵被浼肩殑渚嬪瓙锛屼笉鐭ラ亾浣犳槸涓嶆槸杩欎釜鎰忔€?
test.jsp
<%@ page contentType="text/html;charset=utf-8"%>
<html>
<head>
<title>Test page</title>
</head>
<body>
<table border="1">
<%
for (int i = 0; i < 10; i++) {
String s1 = i + "a";
String s2 = i + "b";
String s3 = i + "c";
%>
<tr>
<td><%=s1%></td>
<td><%=s2%></td>
<td><%=s3%></td>
</tr>
<%
}
%>
</table>
</body>
</html>
test.jsp
<%@ page contentType="text/html;charset=utf-8"%>
<html>
<head>
<title>Test page</title>
</head>
<body>
<table border="1">
<%
for (int i = 0; i < 10; i++) {
String s1 = i + "a";
String s2 = i + "b";
String s3 = i + "c";
%>
<tr>
<td><%=s1%></td>
<td><%=s2%></td>
<td><%=s3%></td>
</tr>
<%
}
%>
</table>
</body>
</html>
#2
<table>
<tr>
<td>缂栧彿</td>
<td>鐢ㄦ埛鍚?lt;/td>
<td>鏂囩珷鍚?lt;/td>
<td>鍐呭</td>
<td>鍒犻櫎</td>
</tr>
<%
LiuYanming id = new LiuYanImpl();
List<LiuYan> list = id.selectAll();
Iterator it=list.iterator();
while(it.hasNext()){
LiuYan liuyans = (LiuYan)it.next();
%>
<tr>
<td><%=liuyans.getId() %></td>
<td><%=liuyans.getUsername()%></td>
<td><%=liuyans.getLname()%></td>
<td><%=liuyans.getLtextarea()%></td>
<td><a href="delete.do?id=<%=liuyans.getId()%>">鍒犻櫎</a></td>
</tr>
<%}%>
</table>
<tr>
<td>缂栧彿</td>
<td>鐢ㄦ埛鍚?lt;/td>
<td>鏂囩珷鍚?lt;/td>
<td>鍐呭</td>
<td>鍒犻櫎</td>
</tr>
<%
LiuYanming id = new LiuYanImpl();
List<LiuYan> list = id.selectAll();
Iterator it=list.iterator();
while(it.hasNext()){
LiuYan liuyans = (LiuYan)it.next();
%>
<tr>
<td><%=liuyans.getId() %></td>
<td><%=liuyans.getUsername()%></td>
<td><%=liuyans.getLname()%></td>
<td><%=liuyans.getLtextarea()%></td>
<td><a href="delete.do?id=<%=liuyans.getId()%>">鍒犻櫎</a></td>
</tr>
<%}%>
</table>
#3
灏辫杩欐牱鍐欏憖:
<html>
<head>
<title> Test page </title>
</head>
<body>
<table border="1">
<%
while(rs.next())
{
String s1=rs.getString(1);
String s2=rs.getString(2);
String s3=rs.getString(3);
out.println(s1+" 娄 "+s2+" 娄 "+s3+" <br> ");
%>
<tr>
<td> <%=s1%> </td>
<td> <%=s2%> </td>
<td> <%=s3%> </td>
</tr>
<%
}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>
浣犺嚜宸辫瘯璇曞惂,绁濅綘濂借繍鍝?..
#4
鎭?nbsp;璋㈣阿 鍑犱綅锛?
鎴戠湅浜嗕笅浣犱滑鐨?nbsp;缁堜簬鏈変簡鎯虫硶锛?
rs=stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
%>
<center>
<%
out.println("鏁版嵁搴撲负锛?+rsmd.getCatalogName(1));
%>
<table border>
<tr align=left>
<%
for(int i=1;i<numberOfColumns+1;i++){
%>
<th align=left><%=rsmd.getColumnName(i)%></th>
<br>
<%
}
%>
</tr>
<%
while(rs.next())
{
%>
<tr align=left>
<%
for(int i=1;i<numberOfColumns+1;i++){
%>
<td align=left><%=rs.getString(i)%></td>
<%
}
%>
</tr>
<%
}
%>
<%
rs.close();
鎴戠湅浜嗕笅浣犱滑鐨?nbsp;缁堜簬鏈変簡鎯虫硶锛?
rs=stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
%>
<center>
<%
out.println("鏁版嵁搴撲负锛?+rsmd.getCatalogName(1));
%>
<table border>
<tr align=left>
<%
for(int i=1;i<numberOfColumns+1;i++){
%>
<th align=left><%=rsmd.getColumnName(i)%></th>
<br>
<%
}
%>
</tr>
<%
while(rs.next())
{
%>
<tr align=left>
<%
for(int i=1;i<numberOfColumns+1;i++){
%>
<td align=left><%=rs.getString(i)%></td>
<%
}
%>
</tr>
<%
}
%>
<%
rs.close();
#5
鏈€缁?nbsp;鍙互瀹屾暣鐨勪互琛ㄦ牸褰㈠紡鏄剧ず浜?nbsp;鍛靛懙 璋㈣阿浜嗗摝锛?
#6
鎴戜篃纰板埌杩囪繖鏍风殑闂锛岄《涓€涓?
#7
鎴戜篃鎯冲疄鐜拌繖涓敤.net鎬庝箞瀹炵幇鍟婏紝璇︾粏璇存槑涓€涓嬪惂 璋㈣阿浜?
#1
缁欎釜浣犵被浼肩殑渚嬪瓙锛屼笉鐭ラ亾浣犳槸涓嶆槸杩欎釜鎰忔€?
test.jsp
<%@ page contentType="text/html;charset=utf-8"%>
<html>
<head>
<title>Test page</title>
</head>
<body>
<table border="1">
<%
for (int i = 0; i < 10; i++) {
String s1 = i + "a";
String s2 = i + "b";
String s3 = i + "c";
%>
<tr>
<td><%=s1%></td>
<td><%=s2%></td>
<td><%=s3%></td>
</tr>
<%
}
%>
</table>
</body>
</html>
test.jsp
<%@ page contentType="text/html;charset=utf-8"%>
<html>
<head>
<title>Test page</title>
</head>
<body>
<table border="1">
<%
for (int i = 0; i < 10; i++) {
String s1 = i + "a";
String s2 = i + "b";
String s3 = i + "c";
%>
<tr>
<td><%=s1%></td>
<td><%=s2%></td>
<td><%=s3%></td>
</tr>
<%
}
%>
</table>
</body>
</html>
#2
<table>
<tr>
<td>缂栧彿</td>
<td>鐢ㄦ埛鍚?lt;/td>
<td>鏂囩珷鍚?lt;/td>
<td>鍐呭</td>
<td>鍒犻櫎</td>
</tr>
<%
LiuYanming id = new LiuYanImpl();
List<LiuYan> list = id.selectAll();
Iterator it=list.iterator();
while(it.hasNext()){
LiuYan liuyans = (LiuYan)it.next();
%>
<tr>
<td><%=liuyans.getId() %></td>
<td><%=liuyans.getUsername()%></td>
<td><%=liuyans.getLname()%></td>
<td><%=liuyans.getLtextarea()%></td>
<td><a href="delete.do?id=<%=liuyans.getId()%>">鍒犻櫎</a></td>
</tr>
<%}%>
</table>
<tr>
<td>缂栧彿</td>
<td>鐢ㄦ埛鍚?lt;/td>
<td>鏂囩珷鍚?lt;/td>
<td>鍐呭</td>
<td>鍒犻櫎</td>
</tr>
<%
LiuYanming id = new LiuYanImpl();
List<LiuYan> list = id.selectAll();
Iterator it=list.iterator();
while(it.hasNext()){
LiuYan liuyans = (LiuYan)it.next();
%>
<tr>
<td><%=liuyans.getId() %></td>
<td><%=liuyans.getUsername()%></td>
<td><%=liuyans.getLname()%></td>
<td><%=liuyans.getLtextarea()%></td>
<td><a href="delete.do?id=<%=liuyans.getId()%>">鍒犻櫎</a></td>
</tr>
<%}%>
</table>
#3
灏辫杩欐牱鍐欏憖:
<html>
<head>
<title> Test page </title>
</head>
<body>
<table border="1">
<%
while(rs.next())
{
String s1=rs.getString(1);
String s2=rs.getString(2);
String s3=rs.getString(3);
out.println(s1+" 娄 "+s2+" 娄 "+s3+" <br> ");
%>
<tr>
<td> <%=s1%> </td>
<td> <%=s2%> </td>
<td> <%=s3%> </td>
</tr>
<%
}
rs.close();
stmt.close();
conn.close();
%>
</table>
</body>
</html>
浣犺嚜宸辫瘯璇曞惂,绁濅綘濂借繍鍝?..
#4
鎭?nbsp;璋㈣阿 鍑犱綅锛?
鎴戠湅浜嗕笅浣犱滑鐨?nbsp;缁堜簬鏈変簡鎯虫硶锛?
rs=stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
%>
<center>
<%
out.println("鏁版嵁搴撲负锛?+rsmd.getCatalogName(1));
%>
<table border>
<tr align=left>
<%
for(int i=1;i<numberOfColumns+1;i++){
%>
<th align=left><%=rsmd.getColumnName(i)%></th>
<br>
<%
}
%>
</tr>
<%
while(rs.next())
{
%>
<tr align=left>
<%
for(int i=1;i<numberOfColumns+1;i++){
%>
<td align=left><%=rs.getString(i)%></td>
<%
}
%>
</tr>
<%
}
%>
<%
rs.close();
鎴戠湅浜嗕笅浣犱滑鐨?nbsp;缁堜簬鏈変簡鎯虫硶锛?
rs=stmt.executeQuery(sql);
ResultSetMetaData rsmd = rs.getMetaData();
int numberOfColumns = rsmd.getColumnCount();
%>
<center>
<%
out.println("鏁版嵁搴撲负锛?+rsmd.getCatalogName(1));
%>
<table border>
<tr align=left>
<%
for(int i=1;i<numberOfColumns+1;i++){
%>
<th align=left><%=rsmd.getColumnName(i)%></th>
<br>
<%
}
%>
</tr>
<%
while(rs.next())
{
%>
<tr align=left>
<%
for(int i=1;i<numberOfColumns+1;i++){
%>
<td align=left><%=rs.getString(i)%></td>
<%
}
%>
</tr>
<%
}
%>
<%
rs.close();
#5
鏈€缁?nbsp;鍙互瀹屾暣鐨勪互琛ㄦ牸褰㈠紡鏄剧ず浜?nbsp;鍛靛懙 璋㈣阿浜嗗摝锛?
#6
鎴戜篃纰板埌杩囪繖鏍风殑闂锛岄《涓€涓?
#7
鎴戜篃鎯冲疄鐜拌繖涓敤.net鎬庝箞瀹炵幇鍟婏紝璇︾粏璇存槑涓€涓嬪惂 璋㈣阿浜?