📄 649028.xml
字号:
<?xml version='1.0' encoding='GB2312'?>
<?xml-stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>玩儿命跑</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>95</credit>
<TopicId>649028</TopicId>
<TopicName>高分求教！！！JSP连接Oracle小程序。</TopicName>
<PostUserId>208073</PostUserId>
<PostUserName>pqda</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>4</ReplyNum>
<PostDateTime>2002-4-15 18:07:48</PostDateTime>
<Point>100</Point>
<ReadNum>0</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>我需要一个用JSP编写的程序通过JDBC与本机oracle连接，实现数据的增删改查功能，请把对应程序在数据库建表的脚本也发给我一份，界面过得去就行。我的信箱：pqda@sohu.com拜托了！！！ 收到程序，马上给分。</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName>知秋一叶</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>105</credit>
<ReplyID>4271516</ReplyID>
<TopicID>649028</TopicID>
<PostUserId>231327</PostUserId>
<PostUserName>zhylg2001</PostUserName>
<Point>80</Point>
<Content><%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%
    java.sql.Connection lConn = null;
    java.sql.Statement lStat = null;
    java.sql.ResultSet lRs = null;
    try
    {     
	DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); 
	String lUrl = "java:oracle:thin:@srver:1521:dbname";
	//java:oracle:thin: 表示使用的是thin驱动
	//@srv:1521: 表示使用的服务器的名字和端口号
	//dbname: 表示数据库的SID
        lConn = DriverManager.getConnection(lUrl,"username","password");
      	lStat = lConn.createStatement();
	//创建表
	String createTableCoffees = "CREATE TABLE COFFEES " +
				    "(COF_NAME VARCHAR(32), SUP_ID INTEGER, PRICE FLOAT, " +
				    "SALES INTEGER, TOTAL INTEGER)";
      	lStat.executeUpdate(createTableCoffees);
	//插入数据
	lStat.executeUpdate("INSERT INTO COFFEES VALUES ('Colombian', 101, 7.99, 0, 0)");
	lStat.executeUpdate("INSERT INTO COFFEES VALUES ('Espresso', 150, 9.99, 0, 0)");
	lStat.executeUpdate("INSERT INTO COFFEES VALUES ('Colombian_Decaf', 101, 8.99, 0, 0)");
	lStat.executeUpdate("INSERT INTO COFFEES VALUES ('French_Roast_Decaf', 49, 9.99, 0, 0)");
  	//查询结果
	lRs = lStat.executeQuery("select * from COFFEES");
	//显示结果
     	out.println("<table>");
      
      	while (lRs.next()) {
        out.print("<tr><td>" + lRs.getString(1));
	//COF_NAME
	out.print(  "<td>" + lRs.getInt(2));
	//SUP_ID
	out.print(  "<td>" + lRs.getFloat(3));
	//PRICE
	out.print(  "<td>" + lRs.getInt(4));
	//SALES
	out.println(  "<td>" + lRs.getInt(5));
	//TOTAL
      	}
      	out.println("</table>");
	lRs.close();
      	lStat.close();
    } catch (SQLException e) {
      throw new ServletException(e);
    } finally {
      try {
        if (lConn != null)
          lConn.close();
      } catch (SQLException e) {
      }
    }
%></Content>
<PostDateTime>2002-4-15 18:20:22</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>jacky</PostUserNickName>
<rank>五级(中级)</rank>
<ranknum>user5</ranknum>
<credit>105</credit>
<ReplyID>4272424</ReplyID>
<TopicID>649028</TopicID>
<PostUserId>30398</PostUserId>
<PostUserName>kkhui</PostUserName>
<Point>10</Point>
<Content>参看ORACLE_HOME/jdbc/下的readme</Content>
<PostDateTime>2002-4-15 19:19:03</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>经历单纯的男人不要奢谈成熟和魅力</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>119</credit>
<ReplyID>4273573</ReplyID>
<TopicID>649028</TopicID>
<PostUserId>172275</PostUserId>
<PostUserName>huyuefox</PostUserName>
<Point>10</Point>
<Content>自己动手才进步的快：zhylg2001(知秋一叶) (  ) 的程序挺好，自己练练又未尝不可呢？</Content>
<PostDateTime>2002-4-15 20:41:17</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>玩儿命跑</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>95</credit>
<ReplyID>4316156</ReplyID>
<TopicID>649028</TopicID>
<PostUserId>208073</PostUserId>
<PostUserName>pqda</PostUserName>
<Point>0</Point>
<Content>多谢了兄弟了，呵呵，不是我自己不想做，是因为我不太会，这个程序是给一个朋友的，他做课程设计，我平时是用delphi的。再次感谢。</Content>
<PostDateTime>2002-4-18 10:20:35</PostDateTime>
</Reply>
</Replys>
</Topic>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -