Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
String url="jdbc:jtds;sqlserver://localhost:1433;DatabaseName=ftbbs;USER=sa;PASSWORD="; Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
%>
上面是源代码,我想知道这段代码正确吗,需要把“localhost”改成数据库目录吗
String url="jdbc:jtds;sqlserver://localhost:1433;DatabaseName=ftbbs;USER=sa;PASSWORD="; Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
%>
上面是源代码,我想知道这段代码正确吗,需要把“localhost”改成数据库目录吗
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
String url="jdbc:jtds;sqlserver://localhost:1433;DatabaseName=ftbbs";
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
还是没出来
String url="jdbc:jtds;sqlserver://127.0.0.1:1433;DatabaseName=ftbbs"; --数据库名称
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 数据库名称改下,localhost改为IP试一下.
String MM_conn_USERNAME = "sa";
String MM_conn_PASSWORD = "";
String MM_conn_STRING = "jdbc:jtds;sqlserver://localhost:1433;DatabaseName=ftbbs";这是我在dw中连接数据库的代码,但是找不到net.sourceforge.jtds.jdbc.Driver类jtds应该放在哪里啊