81,091
社区成员
发帖
与我相关
我的任务
分享谁能告诉我jdbc与sqlserver2000的连接啊！！！！！1
我的数据库名为mydb 表名为user_table；用户名和密码都是123代码是：
<%@ 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.microsoft.jdbc.sqlserver.SQLserverDriver");
sConnStr=new String(url);
out=_out;
}catch(Exception e){
}
}
public void get(){
try{
Connection Conn=DriverManager.getConnection(sConnStr,"123","123");
Statement stmt=Conn.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * FROM user_table");
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>Gender</b>");
out.print("</td>");
out.print("<td>");
out.print("<b>Email</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("Gender"));
out.print("</td>");
out.print("<td>");
out.print(rs.getString("Email"));
out.print("</td>");
out.print("</tr>");
};
out.print("</table>");
}catch(Exception e){
}
}
}
%>
<%
DBget myget=new DBget("jdbc:microsoft:sqlserver://localhost/mydb",out);
myget.get();
%>
</body>
</html>
把我看一下好吗？
<%@ 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.microsoft.jdbc.sqlserver.SQLserverDriver");
sConnStr=new String(url);
out=_out;
}catch(Exception e){
}
}
public void get(){
try{
Connection Conn=DriverManager.getConnection(sConnStr,"123","123");
Statement stmt=Conn.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * FROM user_table");
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>Gender</b>");
out.print("</td>");
out.print("<td>");
out.print("<b>Email</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("Gender"));
out.print("</td>");
out.print("<td>");
out.print(rs.getString("Email"));
out.print("</td>");
out.print("</tr>");
};
out.print("</table>");
}catch(Exception e){
}
}
}
%>
<%
DBget myget=new DBget("jdbc:microsoft:sqlserver://localhost/mydb",out);
myget.get();
%>
</body>
</html>
把我看一下好吗？
...全文
请发表友善的回复…
发表回复
hongsea312 2003-09-06
- 打赏
- 举报
数据库的驱动没装好~`
struggle007csdn 2003-05-21
- 打赏
- 举报
说说你的过程，包括你想干什么，你是怎么做的，想达到什么样的效果，没有达到目标，你又是怎么改的。你说的越详细，别人就越容易帮你解答的。
dike103 2003-05-21
- 打赏
- 举报
不会出错，就是读不了，空白的一片
struggle007csdn 2003-05-21
- 打赏
- 举报
你的出错信息是什么？
