?? main.jsp
字號:
<%@ page language="java" pageEncoding="gb2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="kefu.javabeans.*" %>
<%@taglib uri="http://jakarta.apache.org/struts/tags-bean" prefix="bean"%>
<%@taglib uri="http://jakarta.apache.org/struts/tags-logic" prefix="logic"%>
<html>
<head>
<title>Insert title here</title>
</head>
<body bgcolor="#99CCCC">
<center>
<br>
<h3>積華醫藥藥品一覽表</h3>
<table width="90%" border="0">
<tr bgcolor="#FFCC33">
<td>藥品名稱</td>
<td>藥品單價</td>
<td>藥品類型</td>
<td>藥品描述</td>
</tr>
<%
//String myurl="jdbc:microsoft:sqlserver://10.10.8.184:1433;DataBaseName=JHYY";
//String mydriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
Connection conn;
PreparedStatement stmt;
ResultSet rs;
String sql="select * from druginfo";
DBConnection dbc = new DBConnection();
conn = dbc.getConnection();
try{
stmt=conn.prepareStatement(sql);
rs=stmt.executeQuery();
System.out.println("main數據庫連接成功。。。");
while(rs.next()){
%>
<tr>
<td><%=rs.getString(3)%></td>
<td><%=rs.getFloat(4)%></td>
<td><%=rs.getString(5)%></td>
<td><%=rs.getString(6)%></td>
</tr>
<%
}
}catch(Exception ee){
ee.printStackTrace();
System.out.println("main數據庫連接成功。。。");
}
%>
</table>
</center>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -