import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class DB {
static int i;
class data{
String num;
String name;
String sex;
String age;
String nation;
String type;
String phone;
String add;
}
public static void main(String args[])
{
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver"; //加载JDBC驱动
String dbURL = "jdbc:sqlserver://localhost:1433;DatabaseName=LifeLine"; //连接服务器和数据库sample
String userName = "sa"; //默认用户名
String userPwd = "123456"; //密码
Connection dbConn;
try
{
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
String str1 = "SELECT * FROM 病人信息";
Statement stmt = dbConn.createStatement();
ResultSet rs2 = stmt.executeQuery(str1);
int j = 0;
data[][] aa = new data[4][8];
while((rs2.next()))
{
String dbbrnum = rs2.getString("编号");
String dbbrname = rs2.getString("姓名");
String dbbrsex = rs2.getString("性别");
String dbbrage = rs2.getString("年龄");
String dbminzu = rs2.getString("民族");
String dbfeetype = rs2.getString("费用类型");
String dbphone = rs2.getString("电话");
String dbaddress = rs2.getString("地址");
aa[j][0].num = dbbrnum;//(！！！！！空指针异常出现在这里，不知道哪里出了问题！！！！！)
aa[j][1].name = dbbrname;
aa[j][2].sex = dbbrsex;
aa[j][3].age = dbbrage;
aa[j][4].nation = dbminzu;
aa[j][5].type = dbfeetype;
aa[j][6].phone = dbphone;
aa[j][7].add = dbaddress;
j++;
System.out.print(aa[j][0].num + "\t" + aa[j][1].name + "\t" + aa[j][2].sex + "\t" + aa[j][3].age + "\t" + aa[j][4].nation
+ "\t" + aa[j][5].type + "\t" + aa[j][6].phone + "\t" + aa[j][7].add+"\n");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
