JDBC查询

来源:互联网 发布:全国行政区街道数据库 编辑:程序博客网 时间:2024/05/18 00:38
package com.neusoft;import java.sql.*;public class Main {    public static void main(String[] args) throws ClassNotFoundException, SQLException    {// write your code here        Class.forName("oracle.jdbc.driver.OracleDriver");        String strUrl ="jdbc:oracle:thin:@localhost:1521:orcl";        Connection con = DriverManager.getConnection(strUrl,"scott","a12345");        String strSql = "SELECT * FROM userinfo WHERE userid = ? AND username = ? ";        PreparedStatement ps =  con.prepareStatement(strSql);        ps.setInt(1,1);        ps.setString(2,"admin");        ResultSet rs = ps.executeQuery();        while (rs.next())        {            String strName = rs.getString("username");            Date d = rs.getDate("birtbday");            System.out.println(strName+":"+d);        }        rs.close();        ps.close();        con.close();    }}

0 0
原创粉丝点击