JDBC 链接例子

最新推荐文章于 2024-10-04 22:00:00 发布

aescoty

最新推荐文章于 2024-10-04 22:00:00 发布

阅读量333

点赞数

分类专栏： J2EE 文章标签： jdbc string sql insert oracle url

本文链接：https://blog.csdn.net/aescoty/article/details/5311766

版权

J2EE 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

package com.lzg.example;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class JDBCexample
{

    public static void main(String[] args)
    {
        String driver = "oracle.jdbc.driver.OracleDriver";
        String url = "jdbc:oracle:thin:@aescoty-pc:1521:orcl";
        String username = "scott";
        String password = "a123";
        //String sql = "insert into users(username,password) values(?,?)";
        String sql= "select *from users";
        try
        {
            Class.forName(driver);
            Connection conn = DriverManager.getConnection(url, username,
                    password);
            PreparedStatement pstmt = conn.prepareStatement(sql);
            /*
            pstmt.setString(1, "王燕霞");
            pstmt.setString(2, "67890");
            pstmt.executeUpdate();

            */
            ResultSet rs = pstmt.executeQuery();
            while (rs.next())
            {
                System.out.println("name:"+rs.getString("username")+"/tpassword:"+rs.getString("password"));

            }
            rs.close();
            pstmt.close();
            conn.close();
        } catch (ClassNotFoundException e)
        {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e)
        {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }

}