java sqlserver 2000_java连接SqlServer2000类，比较完整，比较强大

package database;

import java.sql.*;

import javax.swing.JOptionPane;

public class JDBC_CONNECTION {

//驱动名

private String driversql = "com.microsoft.sqlserver.jdbc.SQLServerDriver";

private String driverjtds = "net.sourceforge.jtds.jdbc.Driver";

private String url = "jdbc:sqlserver://localhost:1433;databaseName=Address_Book";

//"jdbc:sqlserver://localhost:2433;databaseName=Address_Book","sa","admin!@#$%^!!"

//"jdbc:jtds:sqlserver://localhost:1433/YGGL","sa","123456"

//服务器名

int count;

int pcout;

public ResultSet rs = null;

public Connection con = null;

public Statement stat = null;

public PreparedStatement pstat = null;

//private String psql = "INSERT INTO TXL(name,picture) VALUES('小屋1',?)";

//建立连接

public void connectDB()

{

try {

Class.forName(driversql);

con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=Address_Book","sa","123456");

stat = con.createStatement();

//pstat = con.prepareStatement(psql);

} catch (Exception e) {

// TODO Auto-generated catch block

JOptionPane.showMessageDialog(null, "数据库连接失败！","错误提示",JOptionPane.ERROR_MESSAGE);

e.printStackTrace();

}

}

//preparedStatement

public void pstconnectDB(String sql)

{

try {

Class.forName(driversql);

con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=Address_Book","sa","123456");

pstat = con.prepareStatement(sql);

} catch (Exception e) {

// TODO Auto-generated catch block

JOptionPane.showMessageDialog(null, "数据库连接失败！","错误提示",JOptionPane.ERROR_MESSAGE);

e.printStackTrace();

}

}

//查询

public void selectDB(String sql)

{

try {

rs = stat.executeQuery(sql);

} catch (SQLException e) {

// TODO Auto-generated catch block

JOptionPane.showMessageDialog(null, "查询失败！","错误提示",JOptionPane.ERROR_MESSAGE);

e.printStackTrace();

}

}

//更新

public int updateDB(String sql)

{

try

{

count = stat.executeUpdate(sql);

}

catch(SQLException e)

{

JOptionPane.showMessageDialog(null, "更新失败！","错误提示",JOptionPane.ERROR_MESSAGE);

e.printStackTrace();

}

return count;

}

//关闭

public void close()

{

try

{

rs.close();

stat.close();

con.close();

}

catch(Exception e)

{

e.printStackTrace();

}

}

public void pstatclose()

{

try

{

rs.close();

pstat.close();

con.close();

}

catch(Exception e)

{

e.printStackTrace();

}

}

}