java学习

来源：互联网发布：广州男装网络批发编辑：程序博客网时间：2024/04/30 02:07

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);

}

*******************************************************************

0 0