但是连不上了
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());
}
}
}
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());
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货