读库
这个文件,可以连接MYSQL,但是连接MSSQL2000就出错,求教啊。
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.sql.*" %>
<html>
<head>
<title>
查询数据库
</title>
</head>
<body>
<%!
class DBget{
String sConnStr;
javax.servlet.jsp.JspWriter out;
DBget(String url,javax.servlet.jsp.JspWriter _out){
try{
Class.forName("com.jnetdirect.jsql.JSQLDriverr");
sConnStr=new String(url);
out=_out;
}catch(Exception e){
}
}
public void get(){
try{
String sConnStr="jdbc:JSQLConnect://127.0.0.1/library";
Connection Conn=DriverManager.getConnection(sConnStr,"sa","hcy");
Statement stmt=Conn.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * FROM userinfo");
out.print("<h2>用户列表</h2>");
out.print("<table border=1>");
out.print("<tr>");
out.print("<td>");
out.print("<b>id</b>");
out.print("</td>");
out.print("<td>");
out.print("<b>name</b>");
out.print("</td>");
out.print("<td>");
out.print("<b>title</b>");
out.print("</td>");
out.print("<td>");
out.print("<b>content</b>");
out.print("</td>");
out.print("</tr>");
while(rs.next()){
out.print("<tr>");
out.print("<td>");
out.print(rs.getString("id"));
out.print("</td>");
out.print("<td>");
out.print(rs.getString("name"));
out.print("</td>");
out.print("<td>");
out.print(rs.getString("title"));
out.print("</td>");
out.print("<td>");
out.print(rs.getString("content"));
out.print("</td>");
out.print("</tr>");
};
out.print("</table>");
}catch(Exception e){
}
}
}
%>
<%
DBget myget=new DBget("jdbc:jrun:sqlserver://127.0.0.1:1433;databaseName=library",out);
myget.get();
%>
</body>
</html>