daobean.java

来自「是对sybasetest.rar的测试程序」· Java 代码 · 共 53 行

package jdbctest;

import java.sql.*;


public class DAOBean {
    private String dbURL = "jdbc:sybase:Tds:66.2.5.108:5000/cqwldb";
    private Connection con;
    private ResultSet rs;

    public DAOBean() {

        try {
            Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        }
    }

    public float[] query(String name) {
        float scores[] = new float[3];
        rs = null;
        try {
            con = DriverManager.getConnection(dbURL, "sa", "123456");
            PreparedStatement pstmt = con.prepareStatement(
                    "select * from scores  where name =?");
            pstmt.setString(1, name);
            rs = pstmt.executeQuery();
            while (rs.next()) {
                float math = rs.getFloat(2);
                float english = rs.getFloat(3);
                float computer = rs.getFloat(4);
                scores[0] = math;
                scores[1] = english;
                scores[2] = computer;
            }
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            try {
                rs.close();
                con.close();
            } catch (Exception exl) {
                exl.printStackTrace();
            }
        }
        return scores;

    }
}