studentdo.java~5~

这是一个用Struts做出来的网上商城的源代码

package com.dao;

import java.sql.*;

public class StudentDo {
  private Connection con;
  private Statement st;
  private ResultSet rs;
  public StudentDo() {
    getConnection();
  }

  public Connection getConnection() {
    try {
      Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    }
    catch (ClassNotFoundException ex) {
    }
    try {
      con = DriverManager.getConnection(
          "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test", "sa",
          "");
    }
    catch (SQLException ex1) {
      ex1.printStackTrace();
    }
    return con;
  }

  public boolean AddStu(String sql) {
    boolean b = false;
    try {
      st = con.createStatement();
      st.executeUpdate(sql);
      b = true;
      st.close();
    }
    catch (SQLException e) {
      b = false;
    }
    return b;
  }

  public ResultSet Serach(String sql) {
    try {
      st = con.createStatement();
      rs = st.executeQuery(sql);
      retrun rs;
    }
    catch (SQLException e) {
      return null;
    }
  }
}