Java连接数据库第一版

来源：互联网发布：初中生 18cm 知乎编辑：程序博客网时间：2024/04/30 13:14
package OneConnection;import java.beans.Statement;import java.sql.Date;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;public class Connection {    private static Connection ConnectionCall=null;    private Connection(){    }    public static Connection Call(){        if (ConnectionCall==null) {            ConnectionCall=new Connection();        }        return ConnectionCall;    }    public void Add() {        try {            Class.forName("oracle.jdbc.driver.OracleDriver");            java.sql.Connection conn = DriverManager.getConnection(                    "jdbc:oracle:thin:@127.0.0.1:1521:shuai", "sys as sysdba",                    "0");            String sql = "insert into Employee values(1,1,1,1,'1',sysdate,sysdate,1,1,1,1,1)";            java.sql.Statement statement = conn.createStatement();            int values = statement.executeUpdate(sql);            System.out.println(values);            statement.close();            conn.close();        } catch (ClassNotFoundException e) {            // TODO Auto-generated catch block            e.printStackTrace();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }    }    public void Select() {        try {            Class.forName("oracle.jdbc.driver.OracleDriver");            java.sql.Connection conn = DriverManager.getConnection(                    "jdbc:oracle:thin:@127.0.0.1:1521:shuai", "sys as sysdba",                    "0");            String sqlselect = "select * from Employee";            java.sql.Statement statment = conn.createStatement();            ResultSet resultset = statment.executeQuery(sqlselect);            while (resultset.next()) {                int id = resultset.getInt("emo_id");                String number = resultset.getString("emp_code");                String name = resultset.getString("emp_name");                String possword = resultset.getString("emp_pwd");                String sex = resultset.getString("emp_sex");                Date joind = resultset.getDate("emo_joind");                Date birth =resultset.getDate("emp_birth");                String address=resultset.getString("emp_address");                String email=resultset.getString("emp_emall");                String pohne=resultset.getString("emp_pohne");                long description=resultset.getLong("emp_descripton");                String dept_id=resultset.getString("dept_id");                System.out.println(id + number + name + possword + sex + joind+birth+address+email+pohne+description+dept_id);            }        } catch (ClassNotFoundException e) {            // TODO Auto-generated catch block            e.printStackTrace();        } catch (SQLException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }    }}
0 0