dbhelper.java~11~

使用jBuilder编译软件编写的火车订票系统 不含数据库

package trainticketprj;
import java.sql.*;
import java.util.Vector;


public class DBHelper {
    public DBHelper() {
    }

    public Connection getConn(){
        Connection  conn = null;
        try
        {
           Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
           conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databasename=train","sa","123456");
        } catch (Exception ex) {
            System.out.println("连接失败 "+ex.getMessage());
        }
        return conn;


    }

    //根据车次查出这个车次的 票的所有 信息 返回一个 集合 (Vector)
    public Vector getTicketByTrainno(String trainno){
        Vector v = new Vector();
        Connection conn = this.getConn();
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            ps = conn.prepareStatement("select * from trainticket where trainno = ?");
            ps.setString(1,trainno);

            rs = ps.executeQuery();
            if(rs.next())
            {
                v.add(rs.getString(2));
                v.add(rs.getString(3));
                v.add(rs.getString(4));
                v.add(rs.getString(5));
            }

        } catch (Exception ex) {
            System.out.println("查询失败"+ex.getMessage());
        } finally {

        }
        return v;

    }










}