JavaÁ¬½ÓSQLServer³öÏÖÁËһЩÎÊÌâ - Java / Java SE

ÕâÊÇÎÒµÄÔ´³ÌÐò¡£
package sqltest;



import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SQLtest {
public SQLtest(){

}
void display() {
Connection con=null;


try{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=MyDB";
String userName = "sa";
String passWord = "sa";
con = DriverManager.getConnection(url, userName , passWord);
Statement stmt=con.createStatement();

int id;
String text;
int age;
ResultSet rs;
String strSQL="Seclet * from Person";
rs=stmt.executeQuery(strSQL);
if(rs.next()){
do{
id=rs.getInt(1);
System.out.print("ID:"+id);
text=rs.getString(2);
System.out.print("ÐÕÃû:"+text);
text=rs.getString(3);
System.out.print("ÐÔ±ð:"+text);
age=rs.getInt(4);
System.out.print("ÄêÁä:"+age);
text=rs.getString("address");
System.out.print("µØÖ·:"+text);
text=rs.getString("phone");
System.out.print("µç»°:"+text);
}while(rs.nex