62,634
社区成员




import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.*;
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;
Map<int, data> aa = new HashMap<int, data>();
while((rs2.next()))
{
data d = new data();
d.num = rs2.getString("编号");
d.name = rs2.getString("姓名");
d.sex = rs2.getString("性别");
d.age = rs2.getString("年龄");
d.nation = rs2.getString("民族");
d.type = rs2.getString("费用类型");
d.phone = rs2.getString("电话");
d.add = rs2.getString("地址");
aa.put(j, d);
j++;
System.out.print(aa.get(j).num + "\t" + aa.get(j).name + "\t" + aa.get(j).sex + "\t" + aa.get(j).age + "\t" + aa.get(j).nation
+ "\t" + aa.get(j).type + "\t" + aa.get(j).phone + "\t" + aa.get(j).add+"\n");
}
catch(Exception e)
{
e.printStackTrace();
}
}
}