java类连接数据库
static String conStr = "jdbc:oracle:thin:@115.159.93.180:1521:ORCL";
static String username = "EOS";
static String password = "123456";
Connection con = null;
Statement stmt = null;
con = DriverManager.getConnection(conStr, username, password);
stmt = con.createStatement();
ResultSet resultSet = stmt.executeQuery("SELECT * FROM ORG_ORGANIZATION WHERE ORGTYPE = 3"); //resultset要先next()
HashMap<Integer,String> resultMap=new HashMap<Integer,String>();
while(resultSet.next()){
int jyid=resultSet.getInt("ORGID");
String jyname=resultSet.getString("ORGNAME");
resultMap.put(jyid,jyname);
}
*******************************************************************