谁能告诉我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>
把我看一下好吗?