📄 427314.xml
字号:
<?xml version='1.0' encoding='GB2312'?>
<?xml:stylesheet type='text/xsl' href='../csdn.xsl'?>
<Topic>
<Issue>
<PostUserNickName>飞鸟</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<TopicId>427314</TopicId>
<TopicName>200分求购JSP连接和操作数据库的原代码（JDK1。3+COMCAT4。0+SQLSERVER 2000）</TopicName>
<PostUserId>130382</PostUserId>
<PostUserName>liufeng_125</PostUserName>
<RoomName>JSP</RoomName>
<ReplyNum>24</ReplyNum>
<PostDateTime>2001-12-18 9:28:11</PostDateTime>
<Point>73</Point>
<ReadNum>164</ReadNum>
<RoomId>28</RoomId>
<EndState>2</EndState>
<Content>如果有一定给加分，我分依次只能给这么多。WINDOWS NT 4。0 系统</Content>
</Issue>
<Replys>
<Reply>
<PostUserNickName></PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>2801716</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>134954</PostUserId>
<PostUserName>hoveyer</PostUserName>
<Point>0</Point>
<Content>Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
String url="jdbc:odbc:user_db"; 
Connection con=DriverManager.getConnection(url,"sa",""); </Content>
<PostDateTime>2001-12-18 9:35:10</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>风之心</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>2802077</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>162140</PostUserId>
<PostUserName>orarmor</PostUserName>
<Point>0</Point>
<Content>Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
Connection con=DriverManager.getConnection("jdbc:odbc:odbc_src","sa",""); </Content>
<PostDateTime>2001-12-18 10:00:10</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>也无风雨也无晴</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>2802661</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>134398</PostUserId>
<PostUserName>xiaoxiao_xiao</PostUserName>
<Point>0</Point>
<Content>1: sql server 2000 jdbc
   Class forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
   Connection conn=DriverManager.getConnection   ("jdbc:microsoft:sqlserver://Myserver:1433;databasename=MyDB","username","password");
2:weblogic JDriver
   Class forName("weblogic.jdbc.mssqlserver4.Driver").newInstance(); 
   Connection conn=DriverManager.getConnection   ("jdbc:webglogic:mssqlserver4:MyDB@Mysever:1433","username","password");
3.IDS Driver
   Class forName("ids.sql.IDSDriver").newInstance(); 
   Connection conn=DriverManager.getConnection   ("jdbc:ids://Myserver:12/conn?dsn='MyDB',"username","password");
</Content>
<PostDateTime>2001-12-18 10:41:35</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>也无风雨也无晴</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>2802698</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>134398</PostUserId>
<PostUserName>xiaoxiao_xiao</PostUserName>
<Point>23</Point>
<Content>1: sql server 2000 jdbc
  Class forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); 
  Connection conn=DriverManager.getConnection  ("jdbc:microsoft:sqlserver://Myserver:1433;databasename=MyDB","username","password");
2:weblogic JDriver
  Class forName("weblogic.jdbc.mssqlserver4.Driver").newInstance(); 
  Connection conn=DriverManager.getConnection  ("jdbc:webglogic:mssqlserver4:MyDB@Mysever:1433","username","password");
3.IDS Driver
  Class forName("ids.sql.IDSDriver").newInstance(); 
  Connection conn=DriverManager.getConnection  ("jdbc:ids://Myserver:12/conn?dsn='MyDB',"username","password");
 
 </Content>
<PostDateTime>2001-12-18 10:44:49</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞鸟</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<ReplyID>2804579</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>130382</PostUserId>
<PostUserName>liufeng_125</PostUserName>
<Point>0</Point>
<Content>能否给一个完整的，我的代码中也有类似的语句，但是执行时出错，
E-MAIL:LXB7794@SINA.COM.CN</Content>
<PostDateTime>2001-12-18 12:48:47</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>猴王</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>100</credit>
<ReplyID>2819258</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>93547</PostUserId>
<PostUserName>kmonkey</PostUserName>
<Point>0</Point>
<Content>ok</Content>
<PostDateTime>2001-12-19 16:47:05</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>英雄无敌</PostUserNickName>
<rank>一级(初级)</rank>
<ranknum>user1</ranknum>
<credit>100</credit>
<ReplyID>2824365</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>57648</PostUserId>
<PostUserName>lusoo</PostUserName>
<Point>0</Point>
<Content>很简单的问题给这么多分，TOMCAT都写错了</Content>
<PostDateTime>2001-12-20 5:30:44</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞鸟</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<ReplyID>2827621</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>130382</PostUserId>
<PostUserName>liufeng_125</PostUserName>
<Point>0</Point>
<Content>笔误吗...</Content>
<PostDateTime>2001-12-20 11:14:58</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>飞鸟</PostUserNickName>
<rank>二级(初级)</rank>
<ranknum>user2</ranknum>
<credit>110</credit>
<ReplyID>2827898</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>130382</PostUserId>
<PostUserName>liufeng_125</PostUserName>
<Point>0</Point>
<Content>能快点发吗？我急需用。</Content>
<PostDateTime>2001-12-20 11:27:55</PostDateTime>
</Reply>
<Reply>
<PostUserNickName>在别处</PostUserNickName>
<rank>四级(中级)</rank>
<ranknum>user4</ranknum>
<credit>100</credit>
<ReplyID>2828103</ReplyID>
<TopicID>427314</TopicID>
<PostUserId>84080</PostUserId>
<PostUserName>colababy</PostUserName>
<Point>50</Point>
<Content>我来也！给你个例子！改改用吧！
/******************************************************** *@Linkdb v3.0    LINK JDBC  AND  DO SQL                *
 *@AUTHOR:YuanLin                                       *
 *@UPDATE:Oct,21,2001                                   *
\********************************************************/             
//定义包opendb
package opendb;
//引入java.sql.*
import java.sql.*;
//包opendb中的类Linkdb
public class Linkdb
{
	
//调用数据库	
//定义数据库连接字符串
/****************************************************************
//1. [ ORACLE ]         
  String sDBDriver="oracle.jdbc.driver.OracleDriver";
  String sConnStr="jdbc:oracle:thin:@192.168.0.144:1521:server";
  String userID="TEST";
  String PassWord="TEST";
  Connection conn=null;
  Statement stmt = null; 
  ResultSet rs=null;
/*****************************************************************/
/***************************************************
//2. [ SQL Server ]       
  String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
  String sConnStr="jdbc:odbc:JSP";
  String userID="TEST";
  String PassWord="TEST";
  Connection conn=null;
  Statement stmt = null; 
  ResultSet rs=null;
/****************************************************/       
/***************************************************
//3. [ MY SQL ]          
  String sDBDriver="org.gjt.mm.mysql.Driver";
  String sConnStr="jdbc:mysql://localhost/test"; 
  //"jdbc:mysql://localhost/forum?user=root&password=admin"; （例子） 
  String userID="test";
  String PassWord="";
  Connection conn=null;
  Statement stmt = null; 
  ResultSet rs=null;
/****************************************************/                                       
/***************************************************/
//4. [ ACCESS ]       参见JSPdevelop Page-231(使用JDBC-ODBC桥访问数据库)
  String sDBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
  String sConnStr="jdbc:odbc:testodbc";
  Connection conn=null;
  Statement stmt = null; 
  ResultSet rs=null;
/****************************************************/
//定义打开数据库连接的函数
public Linkdb()
  {
   try{
        //连接MySql_jdbc驱动程序 
	Class.forName(sDBDriver);}
	//处理异常
   catch(java.lang.ClassNotFoundException e){
	System.err.println("Linkdb():"+e.getMessage());}
  }//end method 
//定义执行Select语句的函数
public ResultSet executeQuery(String sql){
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -