用Java連結SQL Server

標籤：style   blog   color   io   os   java   for   資料   div   

public class ConData{    private String driverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";    private String dbURL="jdbc:sqlserver://localhost:1433;DatabaseName=testData";    private String userName;//="sa"    private String userPwd;//="199369265"    private Vector<Point> data=new Vector<Point>();    private Connection dbConn;        public ConData(String username,String password){        userName=username;        userPwd=password;            }    public void Treat() throws IOException     {        try{            Class.forName(driverName);            dbConn=DriverManager.getConnection(dbURL,userName,userPwd);                      JOptionPane.showMessageDialog(null, "串連資料庫成功");                                Statement state=dbConn.createStatement();               ResultSet rs=state.executeQuery("select * from houst_data");            int R=6370856;            int cnt=0;            while(rs.next()){                String name=rs.getString(1);                double x=rs.getDouble(3);//可以採用列號，也可以採用列名，如"X"                double y=rs.getDouble(4);                int price=rs.getInt(5);                                data.addElement(new Point(name,x,y,price,cnt));                    cnt++;            }        }        catch(Exception e){            e.printStackTrace();            System.out.print("串連失敗!");        }                         }}

 

用Java連結SQL Server