第一个jdbc程序

最新推荐文章于 2024-04-21 18:59:20 发布

shazhenzhong

最新推荐文章于 2024-04-21 18:59:20 发布

阅读量557

点赞数

文章标签： jdbc string website exception oracle database

本文链接：https://blog.csdn.net/shazhenzhong/article/details/2934069

版权

package database;

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

public class OpDB {

public static void exeSQL()
{
  PreparedStatement pre = null ;
  ResultSet res = null;
  String url ="jdbc:oracle:thin:@192.168.1.102:1521:oracle";
  String user ="website";
  String pwd ="website" ;
  String sql ="select * from chengjixinxi";

  try{
  Class.forName("oracle.jdbc.driver.OracleDriver");
  Connection con = DriverManager.getConnection(url,user,pwd);

  pre = con.prepareStatement(sql);
  res = pre.executeQuery();
  while(res.next())
  {
   System.out.println(res.getString("xingming"));
  }
  }catch(Exception e)
  {
   e.printStackTrace();
   System.out.println("worong database quxing!");
  }
}

public static void main(String[] args) {
  System.out.println("before");
  exeSQL();
  System.out.println("end");