能不能用sql 2000的jdbc连接sql 7
--------------------------------------------------------------------------------
能不能用sql 2000的jdbc连接sql 7
网上没有down到 sql 7的driver
??? 类没有问题，用odbc可以连接成功
问题点数：30、回复次数：3Top
1 楼xxmen（）回复于 2004-05-04 19:08:00 得分 30
当然行！Top
2 楼stillfire（恒）回复于 2004-05-04 22:08:41 得分 0
但是连不上了
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import cn.stillfire.util.HTML;
import com.microsoft.jdbc.sqlserver.*;
class DB_faq
{
//String sDBDriver ="sun.jdbc.odbc.JdbcOdbcDriver";
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr ="jdbc:sqlserver:student";
Connection conn=null;
ResultSet rs =null;
public DB_faq()
{
try {
Class.forName(sDBDriver);
} catch (java.lang.ClassNotFoundException e) {
System.err.println("faq(): "+e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
rs=null;
try {
conn=DriverManager.getConnection(sConnStr,"browserole","asdf");
Statement stmt =conn.createStatement();
rs= stmt.executeQuery(sql);
} catch (SQLException ex) {
System.err.println("faq.executeQuery: "+ex.getMessage());
}
return rs;
}
}
public class DB_faqServ_2 //extends HttpServlet
{
/* private DB_faq db=new DB_faq();
public void doPost(HttpServletRequest req,
HttpServletResponse res)
throws ServletException,IOException
{
res.setContentType("text/html");
PrintWriter out=res.getWriter();
ResultSet RS=db.executeQuery("SELECT * FROM faq");
String tt;
while (RS.next())
{
tt=RS.getString("answer"); b
out.print("<li>"+RS.gbetString("subject")+"</li>");
out.print("<pre>"+tt+"</pre>");
}
RS.close();
} */
public static void main(String args[])
{
DB_faq db=new DB_faq();
ResultSet RS=db.executeQuery("SELECT * FROM sc");
try {
System.out.println(RS.getCursorName());
System.out.println(RS.getAsciiStream("c#").toString());
String tt;
while (RS.next()) {
tt = RS.getString("s#");
System.out.println("<LI>" + RS.getString("c#") + "</LI>");
System.out.println("<pre>" + tt + "</pre>");
}
RS.close();
}catch (SQLException e)
{
System.err.println("error: "+e.getMessage());
}
}
}Top
3 楼stillfire（恒）回复于 2004-05-05 12:20:32 得分 0
up一下
指点一下Top
