dbhelper.java~9~

来自「使用jBuilder编译软件编写的火车订票系统 不含数据库」· JAVA~9~ 代码 · 共 55 行

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

        } catch (Exception ex) {

        } finally {

        }


    }










}