我是新手,用的数据库为sql,通常建立连接是在odbc里进行配置
怎样不通过odbc配置建立与数据库的连接呢?
jar文件我已经导过了
private static String DRIVE =
"com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static String SOURSE = "";
private static Connection con = null;
private static PreparedStatement ps = null;
private static ResultSet rs = null;
/**
* 获取Connection
* */
public static Connection getConnection() {
try {
Class.forName(DRIVE);
} catch (ClassNotFoundException ex1) {
}
try {
con = DriverManager.getConnection(SOURSE);
} catch (SQLException ex) {
}
return con;
}SOURSE中应该写什么,请指教下
怎样不通过odbc配置建立与数据库的连接呢?
jar文件我已经导过了
private static String DRIVE =
"com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static String SOURSE = "";
private static Connection con = null;
private static PreparedStatement ps = null;
private static ResultSet rs = null;
/**
* 获取Connection
* */
public static Connection getConnection() {
try {
Class.forName(DRIVE);
} catch (ClassNotFoundException ex1) {
}
try {
con = DriverManager.getConnection(SOURSE);
} catch (SQLException ex) {
}
return con;
}SOURSE中应该写什么,请指教下
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
//mydb为数据库
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
import com.microsoft.jdbc.sqlserver.SQLServerDriver;public class DataSet {
public DataSet() {
} private static final String DRIVER =
"com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static final String URL =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName = s";
// private static final String DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
// private static final String DATASOURSE = "jdbc:odbc:Neo";
private static Connection con = null;
private static PreparedStatement ps = null;
private static ResultSet rs = null; public static Connection getConnection() {
try {
Class.forName(DRIVER);
} catch (ClassNotFoundException ex1) {
}
try {
con = DriverManager.getConnection(URL, "sa", "");
// con = DriverManager.getConnection(DATASOURSE);
} catch (SQLException ex) {
}
return con;
} public static PreparedStatement getPreparedStatement(String sql) {
try {
ps = con.prepareStatement(sql);
} catch (SQLException ex) {
}
return ps;
} public static ResultSet getResultSet() {
try {
rs = ps.executeQuery();
} catch (SQLException ex) {
}
return rs;
}
以上代码如果是利用odbc配置的话是完全正确的,一旦用了JDBC,运行时会报异常??何解?
Windows XP SP2
jdk-1_5_0_06-windows-i586-p.exe
jakarta-tomcat-5.0.28.exe
Sql Server2000
SQL2KSP4
Microsoft SQL Server 2000 Driver for JDBC
一、安装jdk1.5(我的安装目录为C:\Program Files\Java\jdk1.5.0_06)
二、配置JDK的环境变量
1、JAVA_HOME=C:\Program Files\Java\jdk1.5.0_06
2、在PATH变量中加入:%JAVA_HOME%\bin
3、创建classpath变量
4、classpath=.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar(注意不要忘记 . 即当前目录)
三、安装Tomcat 5.0(我的安装目录为D:\Tomcat 5.0)
无需任何配置
四、安装Microsoft SQL Server 2000 SP3以上的补丁
五、安装Microsoft SQL Server 2000 Driver for JDBC(我的安装目录为C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC)
可以拷贝C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib目录中的三个文件
msbase.jar mssqlserver.jar msutil.jar
到三个位置均可以 1、拷贝到JAVA安装目录下
C:\Program Files\Java\jdk1.5.0_06\jre\lib\ext (JDK1.5.0.6)
C:\Program Files\Java\jre1.5.0_08\lib\ext (JDK1.5.0.8)
2、Tomcat的类库目录 D:\Program Files\Apache Software Foundation\Tomcat 5.0\common\lib (Tomcat5)
D:\Program Files\Apache Software Foundation\Tomcat 6.0\lib (Tomcat6)
3、应用程序配置目录
\ch04\WEB-INF\lib\ (ch04为虚拟目录)
注意:拷贝完文件后,一定要重新启动Tomcat服务器。
以下是sql.jsp文件的源代码:
<!--JSP连接SQL SERVER2000数据库的程序-->
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>jsp连接SQL SERVER2000示例</title>
</head>
<body>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jspClass";
/*jspClass为数据库名称 */
String user="sa";
String password="sa";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from grade";
/*class为准备查询的表名*/
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) {
//显示第一、二、三个字段内容
%>
<%=rs.getString(1)%>----
<%=rs.getString(2)%>----
<%=rs.getString(3)%><br>
<%}%> <br><br><br>
<%out.print("数据库操作成功,恭喜你");%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
看看对你有用没。
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
//mydb为数据库
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
估计是机器原因
同样的代码到别人的机器上运作正常
不过还是结贴吧
顺便,给分我现在还不会弄
参考了就把分打过来
谢谢hhgg123()