当前页面: JAVA 编程资料牛鼻论坛 → J2EE Datebase 数据库开发→java怎么连接sql数据库啊? |
先要在工程中加载sql的驱动,我用的是2000的!
import java.sql.*;
import java.util.ResourceBundle;
import java.util.Locale;
import java.io.InputStream;
import java.util.Properties;
import java.io.*;
public class ConnectSQL {
private Connection con;
private ResultSet rs;
private Statement st;
Properties ps;
public ConnectSQL() {
//加载资源文件
//rb=ResourceBundle.getBundle("connection.properties");
InputStream in=this.getClass().getResourceAsStream("connection.properties");
ps=new Properties();
try {
System.out.println("开始加载资源文件...");
ps.load(in);
} catch (IOException ex1) {
System.out.println("无法正确加载资源文件...");
ex1.printStackTrace();
}
//读资源文件,获取驱动信息
String driver=ps.getProperty("driver");
System.out.println("jdbc:driver:"+driver);
try {
//2005JDBC驱动
Class.forName(driver);
//Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); //2000JDBC驱动
} catch (ClassNotFoundException ex) {
}
}
connection.properties 资源文件:
driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://127.0.0.1:1433;DatabaseName=cdstore
user=sa
password=
若有问题可以再问我...xuxiangtour@yahoo.com.cn