Java-JDBC串連Oracle 資料庫

標籤：

package com.zse.oracle;import oracle.jdbc.*;import java.sql.*;import javax.swing.text.html.HTMLDocument.HTMLReader.PreAction;public class Test {    public static void main(String[] args) {                //載入驅動        try {            Class.forName("oracle.jdbc.OracleDriver");            String url="jdbc:oracle:thin:@127.0.0.1:1521:xe";            String user="root";            String pass="111";                        //通過驅動管理器擷取 oracle資料庫連接            Connection conn= DriverManager.getConnection(url, user, pass);                        //添加紀錄            Statement  st=conn.createStatement();            //添加語句            //String sql="insert into student values(3,‘ccc‘,‘444‘)";//設計執行語句                        //修改語句            //String sql="update student set pass=‘999‘ where sid=1";                        //刪除語句            //String sql="delete from student where sid=1";                        //st.execute(sql);//執行語句                        //讀取所有記錄            //String sql="select * from student  where name=‘aaa‘ and pass=‘111‘  order by sid";            //通過查詢返回一個結果                        //模糊查詢            //String sql="select count(*) as num from student where name like ‘%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,5);//            ps.setString(2, "eee");//            ps.setString(3, "888");//            //            ps.execute();                        //先行編譯:修改記錄            //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.setInt(1, 1);//            ps.execute();                        //先行編譯：尋找            String sql="select * from student where name like ?";            PreparedStatement ps=conn.prepareStatement(sql);            ps.setString(1, "%a%");            ResultSet rs = ps.executeQuery();                        //輸出結果            while(rs.next())            {                System.out.println(rs.getString("sid")+";"+rs.getString("name")+";"+rs.getString("pass"));            }                        System.out.println("記錄添加成功");                        //System.out.println("資料庫連接成功");           // System.out.println("記錄添加成功");        } catch (Exception e) {            //e.printStackTrace();            System.out.println("資料庫連接失敗="+e.getMessage());        }    }}

 

Java-JDBC串連Oracle 資料庫