求JAVA代码片段~~~~~~~~~关于从数据库取值 刚学习的,呵呵建了个库,存有username和password,java中如何取出这两个字段的值呢???兄弟们,给个片段就可以了,谢谢了挺急的~~~~~~~~~~~~~~~~~ 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 String sql = "select * from userInfo where id= ?";pstmt = conn.prepareStatement(sql);pstmt.setInt(1,id);ResultSet rs = pstmt.executeUpdate();UserInfo user = new UserInfo();user.setUsername(rs.getString("username"));user.setPassword(rs.getString("password")); 连接数据库,得到ResultSet对象rs然后rs.getString("username")获得username的值,password一样。 用JDBC或任何一种O/R映射工具都可以读给个JDBC的:java.util.Properties info = new java.util.Properties();info.put ("user", "scott");//假设是Oracle下的scott用户info.put ("password", "tiger");//假设密码是tigerConnection conn = null;Statement stmt = null;ResultSet rs = null;String url = "jdbc:oracle:thin:@localhost:1521:orcl";//看你自己的SID是多少,我的是orclString username = null;String password = null;try { conn = DriverManager.getConnection(url,info); stmt = conn.createStatement(); rs = stmt.executeQuery("select username, password from 表名"); while(rs.next()) { username = rs.getString("username"); password = rs.getString("password"); //这里你可以将username与password进行封装,放到另一个东西里面返回,看具体情况} catch(Exception e) {} finally { //一些关闭资源(conn、stmt、rs)的操作,去网上找一个好点的,不写了} 太久没写JDBC代码了,大概就那样,自己去网上找比在这问好得多了 5楼的兄弟,我没有看懂您new个Perpertis对象有什么用呢??能给我讲讲吗??? //连接oracle String url="jdbc:oracle:thin:@localhost:1521:orcl"; //orcl为数据库的SID Statement stmt = null; ResultSet rs = null; String username = "test"; String password = "test"; try { Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); Connection conn= DriverManager.getConnection(url,username,password); stmt = conn.createStatement(); rs = stmt.executeQuery("select username, password from 表名"); while(rs.next()) { username = rs.getString("username"); password = rs.getString("password"); //这里你可以将username与password进行封装,放到另一个东西里面返回,看具体情况 } catch(Exception e) { } finally { if(rs!=null) rs.close(); if(stmt!=null) stmt.close(); if(conn!=null) conn.close(); }//连接mysql String url ="jdbc:mysql://localhost/myDB?username=test&password=test&useUnicode=true&characterEncoding=8859_1" Statement stmt = null; ResultSet rs = null; Connection conn = null; try { Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //myDB为数据库名 conn= DriverManager.getConnection(url); stmt = conn.createStatement(); rs = stmt.executeQuery("select username, password from 表名"); while(rs.next()) { username = rs.getString("username"); password = rs.getString("password"); //这里你可以将username与password进行封装,放到另一个东西里面返回,看具体情况 } catch(Exception e) { } finally { if(rs!=null) rs.close(); if(stmt!=null) stmt.close(); if(conn!=null) conn.close(); } 21875631 java爱好者进!! 1:建立连接 就是Connection2:写好sql3 :编译SQL。4 :取得结果集。5: 从结果集里取得你要的信息。 rs = stmt.executeQuery("select username, password from 表名"); while(rs.next()) { username = rs.getString("username"); password = rs.getString("password"); 请教各位!! 有关Iterator的问题,代码会报java.util.ConcurrentModificationException错 如何用java定义动态二维数组 各位大虾,弱弱地问一句,入门JAVA,应该看什么书? 我的第一个struts程序,遇到无比巨大的困难,恳求高手指点一二。 关于机器语言的问问题 征集日历制作算法 用Url类获取网页内容时遇到的问题 【求助】通过IP访问数据库比较慢。。而用localhost就没问题。。 请问大虾们,如何在jBuilder下将java编译成本地代码 java语言中“接口”与“回调”之间的关系! 多线程问题?
pstmt = conn.prepareStatement(sql);
pstmt.setInt(1,id);
ResultSet rs = pstmt.executeUpdate();
UserInfo user = new UserInfo();
user.setUsername(rs.getString("username"));
user.setPassword(rs.getString("password"));
给个JDBC的:
java.util.Properties info = new java.util.Properties();
info.put ("user", "scott");//假设是Oracle下的scott用户
info.put ("password", "tiger");//假设密码是tigerConnection conn = null;
Statement stmt = null;
ResultSet rs = null;
String url = "jdbc:oracle:thin:@localhost:1521:orcl";//看你自己的SID是多少,我的是orcl
String username = null;
String password = null;
try {
conn = DriverManager.getConnection(url,info);
stmt = conn.createStatement();
rs = stmt.executeQuery("select username, password from 表名");
while(rs.next()) {
username = rs.getString("username");
password = rs.getString("password");
//这里你可以将username与password进行封装,放到另一个东西里面返回,看具体情况
} catch(Exception e) {} finally {
//一些关闭资源(conn、stmt、rs)的操作,去网上找一个好点的,不写了
}
太久没写JDBC代码了,大概就那样,自己去网上找比在这问好得多了
//连接oracle
String url="jdbc:oracle:thin:@localhost:1521:orcl";
//orcl为数据库的SID
Statement stmt = null;
ResultSet rs = null;
String username = "test";
String password = "test";
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection conn= DriverManager.getConnection(url,username,password);
stmt = conn.createStatement();
rs = stmt.executeQuery("select username, password from 表名");
while(rs.next()) {
username = rs.getString("username");
password = rs.getString("password");
//这里你可以将username与password进行封装,放到另一个东西里面返回,看具体情况
} catch(Exception e) { } finally {
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(conn!=null)
conn.close(); }
//连接mysql
String url ="jdbc:mysql://localhost/myDB?username=test&password=test&useUnicode=true&characterEncoding=8859_1" Statement stmt = null;
ResultSet rs = null;
Connection conn = null;
try {
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
//myDB为数据库名
conn= DriverManager.getConnection(url);
stmt = conn.createStatement();
rs = stmt.executeQuery("select username, password from 表名");
while(rs.next()) {
username = rs.getString("username");
password = rs.getString("password");
//这里你可以将username与password进行封装,放到另一个东西里面返回,看具体情况
} catch(Exception e) {
} finally {
if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
if(conn!=null)
conn.close(); }
2:写好sql
3 :编译SQL。
4 :取得结果集。
5: 从结果集里取得你要的信息。
while(rs.next()) {
username = rs.getString("username");
password = rs.getString("password");