连接字符串:jdbc:microsoft:sqlserver://CHENJI\\NETSDK:1433;DatabaseName=jspdev
上面写错了用IP地址吧<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://192.168.0.1:1433;DatabaseName=pubs";
//pubs为你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
上面写错了用IP地址吧<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://192.168.0.1:1433;DatabaseName=pubs";
//pubs为你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
//pubs为你的数据库的
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {%>
您的第一个字段内容为:<%=rs.getString(1)%>
您的第二个字段内容为:<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
给你一个jsp连接sqlserver的代码,供你参考!
* DbConnBean.java
*
* Created on 2004年4月23日, 下午1:41
*/package com.javafans.beans;import java.beans.*;
import java.io.Serializable;
import java.sql.*;
import javax.sql.*;/**
* @author Administrator
*/
public class DbConnBean extends Object implements Serializable {
public static final String PROP_SAMPLE_PROPERTY = "sampleProperty";
private String sampleProperty;
private PropertyChangeSupport propertySupport;
/**
* 数据库驱动类
*/
private String driveClass = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
/**
* 数据库连接URL
*/
private String conntionUrl = "jdbc:microsoft:sqlserver://127.0.0.1:1433";
/**
* 用户名
*/
private String userName = "sa";
/**
* 密码
*/
private String password = "1";
/**
* 数据库连接对象
*/
private Connection dbConn = null;
private java.sql.Statement stmt = null;
private java.sql.ResultSet rs=null;
private java.sql.ResultSetMetaData rsmd = null
;
public DbConnBean() {
propertySupport = new PropertyChangeSupport(this);
try
{
//建立驱动类
Class.forName(this.getDriverClass());
//获取一个连接
dbConn=DriverManager.getConnection(this.getConnectionUrl(),this.getUserName(), this.getPassWord());
//建立一个语句对象
java.sql.Statement stmt=dbConn.createStatement();
//执行一个SQL
java.sql.ResultSet rs=stmt.executeQuery("select * from dbo.sysusers");
//显示结果行数
int rows=rs.getRow();
//显示
System.out.println(rows);
//关闭
rs.close();
//关闭
stmt.close();
dbConn.close();
}
catch(ClassNotFoundException err)
{
System.out.println(err.getMessage());
}
catch(SQLException err)
{
System.out.println(err.getMessage());
}
}
public String getSampleProperty() {
return sampleProperty;
}
public void setSampleProperty(String value) {
String oldValue = sampleProperty;
sampleProperty = value;
propertySupport.firePropertyChange(PROP_SAMPLE_PROPERTY, oldValue, sampleProperty);
}
public void addPropertyChangeListener(PropertyChangeListener listener) {
propertySupport.addPropertyChangeListener(listener);
}
public void removePropertyChangeListener(PropertyChangeListener listener) {
propertySupport.removePropertyChangeListener(listener);
}
/**
* Getter for property driverClass.
* @return Value of property driverClass.
*/
public String getDriverClass() {
return this.driveClass;
}
/**
* Setter for property driverClass.
* @param driverClass New value of property driverClass.
*/
public void setDriverClass(String driverClass) {
this.driveClass=driverClass;
}
/**
* Getter for property connectionUrl.
* @return Value of property connectionUrl.
*/
public String getConnectionUrl() {
return this.conntionUrl;
}
/**
* Setter for property connectionUrl.
* @param connectionUrl New value of property connectionUrl.
*/
public void setConnectionUrl(String connectionUrl) {
this.conntionUrl=connectionUrl;
}
/**
* Getter for property userName.
* @return Value of property userName.
*/
public String getUserName() {
return this.userName;
}
/**
* Setter for property userName.
* @param userName New value of property userName.
*/
public void setUserName(String userName) {
this.userName=userName;
}
/**
* Getter for property passWord.
* @return Value of property passWord.
*/
public String getPassWord() {
return this.password;
}
/**
* Setter for property passWord.
* @param passWord New value of property passWord.
*/
public void setPassWord(String passWord) {
this.password=passWord;
}
public static void main(String[] args) {
DbConnBean test=new DbConnBean();
}
}
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
StringBuffer sb = new StringBuffer(0);
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:ocbc:librarianDb","harpo","swordfish");
....
}
这是一个示例,很多情况按照readme来做也不一定能通,主要得多试几种情况,把可能的写法都试一试。我曾经就是按照说明文档来连,说明文档是:
The basic format of a service URL is: jdbc:oracle:thin:[<user>/<password>]@//<host>[:<port>]/<service> Example: jdbc:oracle:thin:@//myserver.com/customer_db
然后我写成:
DriverManager.registerDriver(new oracle.jdbc.OracleDriver()); String url = "jdbc:oracle:oci8:@jlfkajfkl";
就对了。
%>
jdbc:microsoft:sqlserver://127.0.0.1\sqlservername:1433;DatabaseName=yourwebdb
你的
jdbc:microsoft:sqlserver://CHENJI\\NETSDK:1433;DatabaseName=jspdev
“\\”是不是无须用转义,你试试。
我要连接的数据库是Sql Server 2000,实例名是CHENJI\\NETSDK,不是其他的数据库,也不是默认的实例名。特别感谢lhbf(牧野) ,我也一直在调这个地方,你说的方法我也试了,但是系统给出了很准确地错误提示:
---------------------------------------------------------------------------
An error occurred at line: 8 in the jsp file: /jspdev/include.incGenerated servlet error:
String SERVANDDB="jdbc:microsoft:sqlserver://CHENJI\NETSDK:1433;DatabaseName=jspdev";
-----------------------------------------------------------------------------我现在怀疑是端口号1433不对,但不知道应该改成什么样?