Public classcondata{PrivateString drivername= "Com.microsoft.sqlserver.jdbc.SQLServerDriver"; PrivateString dburl= "Jdbc:sqlserver://localhost:1433;databasename=testdata"; PrivateString UserName;//= "sa" PrivateString userpwd;//= "199369265" PrivateVector<point> Data=NewVector<point>(); PrivateConnection Dbconn; Publiccondata (String username,string password) {username=username; Userpwd=password; } Public voidTreat ()throwsIOException {Try{class.forname (drivername); Dbconn=drivermanager.getconnection (DBURL,USERNAME,USERPWD); Joptionpane.showmessagedialog (NULL, "Connection database succeeded"); Statement State=dbconn.createstatement (); ResultSet RS=state.executequery ("SELECT * from Houst_data"); intr=6370856; intCnt=0; while(Rs.next ()) {String name=rs.getstring (1); DoubleX=rs.getdouble (3);//You can use a column number, or you can use a column name, such as"X" DoubleY=rs.getdouble (4); intPrice=rs.getint (5); Data.addelement (NewPoint (name,x,y,price,cnt)); CNT++; } } Catch(Exception e) {e.printstacktrace (); System.out.print ("Connection Failed!"); } }}
Link SQL Server with Java