这是上篇文章的源码?请高手指教!

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();
    }
    }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值