- import java.security.interfaces.RSAKey;
- importoracle.jdbc.*;
- importjava.sql.*;
- public class TestOracle {
- /**
- * @param args
- */
- public static void main(String[] args) {
- // 载入驱动
- try {
- Class.forName("oracle.jdbc.OracleDriver");
- //以下url的获取:window--Open Perspective-->MyEclipse DataBase Browser--new--driver templete选择thin ,
- //username,pass,jar包等这些都写一下、导入一下。然后测试一下,如果提示成功,就可以复制那个URL
- //url:jdbc:oracle:thin:@<server>[:<1521>]:<database_name>String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";//数据库连接地址String user="root";//数据库用户名String pass="111";//密码
- //通过驱动管理器获取oracle数据库连接Connection conn=DriverManager.getConnection(url,user,pass);
- //添加记录Statement st=conn.createStatement();
- //添加语句
- //String sql1="insert into student values(1,'aaa','123')";String sql2="insert into student values(2,'bbb','20170107')";
- //修改语句 String sql3="update student set pass='99912' where sid=1";
- //删除语句
- //String sql="delete from sudent where sid=1";
- //执行语句
- //st.execute(sql1);
- //st.execute(sql3);
- //查询语句(读取所有记录)
- //String sql="select * from student order by sid ";
- //String sql="select * from student where name='aaa' and pass='111' order by sid ";
- //模糊查询
- //String sql="select * from student where name like 'a%' "; //'a%':以a开头。'_a%'
- //ResultSet rs = st.executeQuery(sql);
- //遍历结果输出记录:
- //判断是否有下一条记录存在,如果存在则游标往后移动一格
- // while (rs.next()) {
- // System.out.println(rs.getString("sid")+";"+rs.getString("name")+";"+rs.getString("pass"));
- // //System.out.println(rs.getString("num"));
- // }
- //预编译:记录插入String sql="insert into student values(?,?,?)";//?进行占位,后预编译。PreparedStatement ps=conn.prepareStatement(sql);
- //输入参数ps.setInt(1, 6);//第一个是参数索引,第二个是值。ps.setString(2, "sss");
- ps.setString(3,"18");
- if (ps.execute()) {
- System.out.println("记录添加成功");
- }
- //预编译:修改记录
- // String sql="update student set pass=? where name=?";
- // PreparedStatement ps=conn.prepareStatement(sql);
- // ps.setString(1, "666");
- // ps.setString(2, "aaa");
- //
- // ps.execute();
- //
- //预编译:删除记录
- // String sql="delete from student where sid=?";
- // PreparedStatement ps=conn.prepareStatement(sql);
- // ps.setIn(1, 1);
- //
- // ps.execute();
- // //预编译:查找
- // String sql="select * from student where name like ? "; //这里只能是问号,问号不能放在字符串里面
- // PreparedStatement ps=conn.prepareStatement(sql);
- // ps.setString(1, "%a%"); //模糊查询条件在这里给出
- //
- // rs=ps.executeQuery();
- //
- // //输出结果
- // while (rs.next()) {
- // System.out.println(rs.getString("sid")+";"+rs.getString("name")+";"+rs.getString("pass"));
- // }
- //System.out.println("数据库连接成功");System.out.println("记录添加成功");
- } catch (ClassNotFoundException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- }
来源: