想把表中的数据显示出来解决办法
日期：2014-05-18 浏览次数：20705 次
想把表中的数据显示出来
想把表中的数据显示出来.
package gonggao;
import java.sql.*;
public class Ggmain {
private String url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydata;user=sa;password=520 ";
public Ggmain(){
try{
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
}
catch (Exception ex){
ex.printStackTrace();
}
}
}
---------------------------------------
JSP文件调用BEAN
<%@ page contentType= "text/html; charset=gb2312 " language= "java " import= "java.sql.* " errorPage= " " %>
<jsp:useBean id= "Ggmain " class= "gonggao.Ggmain " scope= "page "> </jsp:useBean>
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<title> 无标题文档 </title>
<link href= "css/textbox.css " rel= "stylesheet " type= "text/css ">
</head>
<body>
<%
Connection con=null;
PreparedStatement Ggps=null;
ResultSet Ggrs=null;
String sqlGg= "select * from Ggaotabelme ";
con=DriverManager.getConnection(url);
Ggps=con.prepareStatement(sqlGg);
Ggrs=Ggps.executeQuery();
if(Ggrs.next()){
%>
<table width= "100% " border= "0 " cellspacing= "0 " cellpadding= "0 ">
<tr>
<td> <p> </p>
<table width= "50% " border= "0 " align= "center " cellpadding= "0 " cellspacing= "0 ">
<tr>
<td> <form name= "form1 " method= "post " action= " ">
<div align= "center "> 公告内容 <br>
<br>
<textarea name= "textfield " cols= "60 " rows= "20 " class= "textbox "> <%=Ggrs.getString( "G_res ")%> </textarea>
</div>
</form> </td>
</tr>
</table>
<p align= "center "> </p> </td>
</tr>
</table>
<%}
Ggrs.close();
Ggps.close();
con.close();
%>
</body>
</html>
----------------------------
con=DriverManager.getConnection(url
想把表中的数据显示出来.
package gonggao;
import java.sql.*;
public class Ggmain {
private String url= "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydata;user=sa;password=520 ";
public Ggmain(){
try{
Class.forName( "com.microsoft.jdbc.sqlserver.SQLServerDriver ");
}
catch (Exception ex){
ex.printStackTrace();
}
}
}
---------------------------------------
JSP文件调用BEAN
<%@ page contentType= "text/html; charset=gb2312 " language= "java " import= "java.sql.* " errorPage= " " %>
<jsp:useBean id= "Ggmain " class= "gonggao.Ggmain " scope= "page "> </jsp:useBean>
<html>
<head>
<meta http-equiv= "Content-Type " content= "text/html; charset=gb2312 ">
<title> 无标题文档 </title>
<link href= "css/textbox.css " rel= "stylesheet " type= "text/css ">
</head>
<body>
<%
Connection con=null;
PreparedStatement Ggps=null;
ResultSet Ggrs=null;
String sqlGg= "select * from Ggaotabelme ";
con=DriverManager.getConnection(url);
Ggps=con.prepareStatement(sqlGg);
Ggrs=Ggps.executeQuery();
if(Ggrs.next()){
%>
<table width= "100% " border= "0 " cellspacing= "0 " cellpadding= "0 ">
<tr>
<td> <p> </p>
<table width= "50% " border= "0 " align= "center " cellpadding= "0 " cellspacing= "0 ">
<tr>
<td> <form name= "form1 " method= "post " action= " ">
<div align= "center "> 公告内容 <br>
<br>
<textarea name= "textfield " cols= "60 " rows= "20 " class= "textbox "> <%=Ggrs.getString( "G_res ")%> </textarea>
</div>
</form> </td>
</tr>
</table>
<p align= "center "> </p> </td>
</tr>
</table>
<%}
Ggrs.close();
Ggps.close();
con.close();
%>
</body>
</html>
----------------------------
con=DriverManager.getConnection(url
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
