数据源难道就不行么?
如果你不想用数据源,那么看看这几篇文章吧
http://www.csdn.net/expert/topic/679/679478.xml?temp=.1723902
http://www.csdn.net/expert/topic/651/651686.xml?temp=.4644129
其实论坛里面有很多这些文章
你上面所说dbURL其实指的是你下载的数据库驱动,如下所例:
Connection c = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=test","sa","hcg888");
如果你不想用数据源,那么看看这几篇文章吧
http://www.csdn.net/expert/topic/679/679478.xml?temp=.1723902
http://www.csdn.net/expert/topic/651/651686.xml?temp=.4644129
其实论坛里面有很多这些文章
你上面所说dbURL其实指的是你下载的数据库驱动,如下所例:
Connection c = DriverManager.getConnection("jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=test","sa","hcg888");
public class dbtest {
public static void main(String[] args) {
Connection con = null;
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
System.out.println("JDBC Driver loaded");
con = DriverManager.getConnection("jdbc:mysql://localhost/mysql?user=root&password=pass");
System.out.println("Database connected");
}catch (ClassNotFoundException cnfe) {
System.out.println(" Could Not Locate Driver");
}catch (Exception e) {
System.out.println(" Unknown error1 ");
}finally {
try{
if(con!=null) con.close();
}catch (Exception e) {
System.out.println(" Unknown error2 ");
}
} }
}
conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://server1:1433;DatabaseName=pubs","sa","8421");