请高人指点:JBuilder 2007与SQL server 2000连接的问题!
来源:百度知道 编辑:UC知道 时间:2024/06/28 12:15:59
import java.sql.*;
public class cardConnect {
public cardConnect() {
try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
}
catch(ClassNotFoundException ee){
}
}
public static Connection getconn() throws SQLException{
String url = "jdbc:microsoft:sqlserver://hust-5cf3f8f222:1433;DatabaseName=pdx";
String username= "sa";
String password= "";
return DriverManager.getConnection(url,username,password);
}
public static void close(ResultSet rs){
try{
rs.close();
}
catch(Exception ex){
你做的有些乱;我给你个吧!记得给我加分就行了!哈哈
package emp_Dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Vector;
import java.sql.SQLException;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2008</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class Connemp {
public static Connection getConnection(String uli) {
Connection conn = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(uli);
} catch (SQLException ex) {
System.out.println(ex);
} catch (ClassNotFoundException x) {
System.out.println