package jp.co.rct.jj.xfr.action.chintai.common;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class test {
public static void main(String[] Str) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException{
//驱动加载
String dirver = "oracle.jdbc.OracleDriver";
Class.forName(dirver).newInstance();
//数据库连接
Connection conn = null;
conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.192:1521:ORCL","TEST0111","111");
//SQL语句对象生成
//String sql = "SELECT ID, MODEL, MODEL_YEAR FORM CAR WHERE MODEL_YEAR=?";
String sql = "SELECT ACT_CODE, ACT_NAME, ACT_TYPE_CODE FROM ACT_MASTER";
PreparedStatement s = conn.prepareStatement(sql);
// 设置条件
// 参数第一个代表where条件中的第几个参数
//s.setString(1, "1986");
ResultSet rs = s.executeQuery();
while(rs.next()){
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(2));
}
rs.close();
s.close();
conn.close();
}
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class test {
public static void main(String[] Str) throws InstantiationException, IllegalAccessException, ClassNotFoundException, SQLException{
//驱动加载
String dirver = "oracle.jdbc.OracleDriver";
Class.forName(dirver).newInstance();
//数据库连接
Connection conn = null;
conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.192:1521:ORCL","TEST0111","111");
//SQL语句对象生成
//String sql = "SELECT ID, MODEL, MODEL_YEAR FORM CAR WHERE MODEL_YEAR=?";
String sql = "SELECT ACT_CODE, ACT_NAME, ACT_TYPE_CODE FROM ACT_MASTER";
PreparedStatement s = conn.prepareStatement(sql);
// 设置条件
// 参数第一个代表where条件中的第几个参数
//s.setString(1, "1986");
ResultSet rs = s.executeQuery();
while(rs.next()){
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(2));
}
rs.close();
s.close();
conn.close();
}
}