当前位置: 代码迷 >> Java Web开发 >> 关于JAVA从ORACLE里取出数据如何放入LIST里
  详细解决方案

关于JAVA从ORACLE里取出数据如何放入LIST里

热度:5264   发布时间:2013-02-25 21:18:13.0
关于JAVA从ORACLE里取出数据怎么放入LIST里?
<%@ page language="java" import="java.sql.*,java.util.*" pageEncoding="gb2312"%> 
<% 
String path = request.getContextPath(); 
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; 
//1.加载驱动 
Class.forName("oracle.jdbc.driver.OracleDriver"); 
//2.找开连接 
String OracleURL = "jdbc:oracle:thin:@192.168.4.202:1521:ujpcn"; 
Connection conn=DriverManager.getConnection(OracleURL,"netcool","netcool"); 
//xxxx这里是数据库的用户名,****这里是数据库的密码。 
//3.创建statement 
Statement stat=conn.createStatement(); 

%> 


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> 
<html> 
  <head> 
  <base href=" <%=basePath%>"> 
   
  <title>My JSP 'MyJsp.jsp' starting page </title> 
   
<meta http-equiv="pragma" content="no-cache"> 
<meta http-equiv="cache-control" content="no-cache"> 
<meta http-equiv="expires" content="0">  
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> 
<meta http-equiv="description" content="This is my page"> 
<!-- 
<link rel="stylesheet" type="text/css" href="styles.css"> 
--> 

  </head> 
  
<body> 

  <div align="center">&quot;自由短信发送页面 </div> 
  <form id="form1" name="form1" method="post" action=""> 
  <label> 
  <div align="center">短信内容编写栏: 
  (每条短信可含60个字符,超出将被拆分) 
  <input type="submit" name="Submit7" value="发送短信" /> 
  <input type="submit" name="Submit" value="退出" /> 
  </div> 
  </label> 
  <label> </label> 
  <label> 
  <div align="center"> 
  <textarea name="textarea3" cols="60" rows="8"> </textarea> 
  <br /> 
  <div align="center"> <br /> 
  </div> 
  </div> 
  </label> 
  </form> 
  <div align="center"> 
  <table width="545" height="22" border="0"> 
  <tr> 
  <td width="225"> <div align="center">可选收件人列表 </div> </td> 
  <td width="77">&nbsp; </td> 
  <td width="229"> <div align="center">已选收件人列表 </div> </td> 
  </tr> 
  </table> 
  <table width="410" border="0" height="330"> 
   
  <tr> 
  <td valign="top"> <br> </td> <td width="227" rowspan="6"> 
  <select id="s1" onpropertychange="javascript:checkButtonStatus();" multiple style="WIDTH: 147px; HEIGHT: 200px"> 
  相关解决方案