package bbsdb;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
/**
* <p>Title: </p>
*
* <p>Description: </p>
*
* <p>Copyright: Copyright (c) 2006</p>
*
* <p>Company: </p>
*
* @author not attributable
* @version 1.0
*/
public class BbsDB {
private Connection conn;
private String url;
private String ServerName;
private String portNumber;
private String databaseName;
private String userName;
private String password;
private String sql;
public BbsDB() {
url = "jdbc:microsoft:sqlserver://";
ServerName = "jinlong";
portNumber = "1433";
databaseName = "bbs";
userName = "sa";
password = "aa";
}
private String getConnectionUrl(){
return url + ServerName + ":" + portNumber + ";databaseName=" + databaseName + ";";
}
private Connection getConnection(){
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
conn = DriverManager.getConnection(getConnectionUrl(),userName,password);
if (conn != null){
System.out.println("连接成功!");
}
} catch (ClassNotFoundException ex) {
ex.printStackTrace();
System.out.println("getConnection() 内的错误跟踪!" + ex.getMessage());
} catch (SQLException ex) {
System.out.println(ex);
/** @todo Handle this exception */
}
return conn;
}
public void display(){
try {
conn = getConnection();
PreparedStatement pstmt = conn.prepareStatement(
"update bbsusers set Upassword = ? where Uname = ? ");
pstmt.setString(1, "19820113");
pstmt.setString(2, "可卡因");
pstmt.executeUpdate();
System.out.println("记录已更新!");
Statement s = conn.createStatement();
String sql = "select * from bbsusers";
ResultSet rs = s.executeQuery(sql);
while (rs.next()){
System.out.println(" ");
System.out.print(rs.getString(1) + "/t");
System.out.print(rs.getString(2) + "/t");
System.out.print(rs.getString(3) + "/t");
System.out.print(rs.getString(4) + "/t");
System.out.print(rs.getString(5) + "/t");
System.out.print(rs.getString(6) + "/t");
System.out.print(rs.getString(7) + "/t");
System.out.print(rs.getString(8) + "/t");
System.out.print(rs.getString(9) + "/t");
System.out.print(rs.getString(10) + "/t");
System.out.println("");
System.out.println("********************************************");
}
} catch (SQLException ex) {
System.out.println(ex);
}
}
public static void main(String [] agrs){
BbsDB retobj = new BbsDB();
retobj.getConnection();
}
}