📄 selectusertable1.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%request.setCharacterEncoding("gb2312");%>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<%!
public String codeToString(String str)
{
String s=str;
try
{
byte tempB[]=s.getBytes("ISO-8859-1");
s=new String(tempB);
return s;
}
catch(Exception e)
{
return s;
}
}
%>
<%
Connection con;
Statement sql;
ResultSet rs;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(ClassNotFoundException e)
{
out.print("类找不到!");
}
// try
// {
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ywjygl","newjygl","enjoyment");
sql=con.createStatement();
rs=sql.executeQuery("select * from dic_base");
out.print("<Table Border>");
out.print("<TR><td colspan=8 align=center>用户数据</td></tr>");
out.print("<TR>");
out.print("<Td width=100>"+"ID");
out.print("<Td width=100>"+"Fir_ID");
out.print("<Td width=100>"+"Sec_ID");
out.print("<Td width=200>"+"MC");
out.print("<Td width=50>"+"TYPE");
out.print("<Td width=50>"+"BS");
out.print("</TR>");
while(rs.next())
{ out.print("<TR>");
out.print("<TD>"+rs.getString(1)+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("<TD>"+rs.getString(3)+"</TD>");
out.print("<TD>"+codeToString(rs.getString(4))+"</TD>");
out.print("<TD>"+rs.getString(5)+"</TD>");
out.print("<TD>"+rs.getString(6)+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
con.close();
// }
// catch(SQLException e1)
// {
// out.print("SQL异常!");
// }
%>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -