第一个的代码如下:
package bookstore;
import java.sql.*;
public class DBConnection {
public static Connection getConnection() throws SQLException {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}catch (ClassNotFoundException ex) {
ex.printStackTrace();
return null;
}
String user = "sa";
String password = "sa";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
return DriverManager.getConnection(url,user,password);
}
}
第二个的代码如下:
package bookstore;
import java.sql.*;
import javax.swing.JOptionPane;
public class UserList
{
public static String getUserListHTML() {
Connection conn = null;
StringBuffer sBuf = new StringBuffer();
try {
conn=DBConnection.getConnection();//这个地方出错说找不到DBConnection
Statement stmt = conn.createStatement();
String sql = "select * from user_tb";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
sBuf.append(rs.getString("user_id").toString);
}
rs.close();
return sBuf.toString();
} catch (SQLException ex) {
ex.printStackTrace();
return "";
} finally {
try {
if (conn != null) {
conn.close();
conn = null;
}
} catch (SQLException ex1) {
}
}
}
}
我的在dos 下编译的.在编译第二个时总是出现variable DBConnection,是不是两个的package 名相同为:bookstore 还是什么原因.这两个文件是同在一个目录下的,我是先编译第一个,再编译第二个文件的.不知那位能帮一下我?
package bookstore;
import java.sql.*;
public class DBConnection {
public static Connection getConnection() throws SQLException {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}catch (ClassNotFoundException ex) {
ex.printStackTrace();
return null;
}
String user = "sa";
String password = "sa";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb";
return DriverManager.getConnection(url,user,password);
}
}
第二个的代码如下:
package bookstore;
import java.sql.*;
import javax.swing.JOptionPane;
public class UserList
{
public static String getUserListHTML() {
Connection conn = null;
StringBuffer sBuf = new StringBuffer();
try {
conn=DBConnection.getConnection();//这个地方出错说找不到DBConnection
Statement stmt = conn.createStatement();
String sql = "select * from user_tb";
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()){
sBuf.append(rs.getString("user_id").toString);
}
rs.close();
return sBuf.toString();
} catch (SQLException ex) {
ex.printStackTrace();
return "";
} finally {
try {
if (conn != null) {
conn.close();
conn = null;
}
} catch (SQLException ex1) {
}
}
}
}
我的在dos 下编译的.在编译第二个时总是出现variable DBConnection,是不是两个的package 名相同为:bookstore 还是什么原因.这两个文件是同在一个目录下的,我是先编译第一个,再编译第二个文件的.不知那位能帮一下我?
再javac -d . UserList.java
然后把dos的当前目录切换到bookstore的上一层,然后直接编译javac bookstore\UserList.java
这样会自动帮你编译DBConnection.java我试过了可以运行 sBuf.append(rs.getString("user_id").toString);这句有错加上()