JDBC连接oracle数据库
发布网友
发布时间:2022-04-07 16:22
我来回答
共2个回答
热心网友
时间:2022-04-07 17:52
要写完很费劲啊,就给你写一个增加记录吧。
为了测试 先要加一个实体类,
public class TeacherVo
{
private int number;
private String name;
private String date;
private double salary;
public int getNumber() {
return number;
}
public void setNumber(int number) {
this.number = number;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getDate() {
return date;
}
public void setDate(String date) {
this.date = date;
}
public double getSalary() {
return salary;
}
public void setSalary(double salary) {
this.salary = salary;
}
}
然后再TeacherDao类里面写方法
public void add(TeacherVo vo)
{
Class.forName("oracle.jdbc.driver.OracleDriver");
con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:ORCL","scott","oracle");
PreparedStatement ps=con.prepareStatement("insert into stuinfo values(?,?,?,?)");
ps.setInt (1,vo.getgetNumber());
ps.setString(2,vo.getName());
java.util.Date date=new SimpleDateFormat("yyyy-MM-dd").parse(vo.getDate());
ps.setDate(3, new java.sql.Date(date.getTime()));
ps.setDouble(4,vo.getSalary());
ps.executeUpdate();
ps.close();
System.out.println("连接成功");
}
catch (Exception e) {
System.out.println("连接失败!");
e.printStackTrace();
}
finally
{
try {
if(con!=null)
con.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}
public static void main(String[] args)
{
TeacherVo vo=new TeacherVo();
vo.setNumber("1");
vo.setsetName("张三");
vo.setDate("1992-07-06");
vo.setSalary("4000");
TeacherDao =new TeacherDao();
.add(vo);
}
热心网友
时间:2022-04-07 19:10
--2.插入
insert into teacher (ID, NAME, BIRTHDAY, SALARY)
values (1, '张三1', to_date('01-02-1978', 'dd-mm-yyyy'), 2500.00);
insert into teacher (ID, NAME, BIRTHDAY, SALARY)
values (2, '李四1', to_date('20-10-1968', 'dd-mm-yyyy'), 3500.00);
insert into teacher (ID, NAME, BIRTHDAY, SALARY)
values (3, '张三2', to_date('01-02-1978', 'dd-mm-yyyy'), 2600.00);
insert into teacher (ID, NAME, BIRTHDAY, SALARY)
values (4, '李四2', to_date('20-10-1968', 'dd-mm-yyyy'), 3200.00);
insert into teacher (ID, NAME, BIRTHDAY, SALARY)
values (5, '张三3', to_date('01-12-1978', 'dd-mm-yyyy'), 2520.00);
insert into teacher (ID, NAME, BIRTHDAY, SALARY)
values (6, '李四3', to_date('20-08-1967', 'dd-mm-yyyy'), 3220.00);
insert into teacher (ID, NAME, BIRTHDAY, SALARY)
values (7, '张三4', to_date('21-02-1975', 'dd-mm-yyyy'), 2650.00);
insert into teacher (ID, NAME, BIRTHDAY, SALARY)
values (8, '李四4', to_date('20-10-1962', 'dd-mm-yyyy'), 3500.00);
insert into teacher (ID, NAME, BIRTHDAY, SALARY)
values (9, '张三5', to_date('01-02-1971', 'dd-mm-yyyy'), 2500.00);
insert into teacher (ID, NAME, BIRTHDAY, SALARY)
values (10, '李四5', to_date('20-10-1968', 'dd-mm-yyyy'), 3500.00);
commit;
--3.查询
dbms_output.put_line(select id, name, birthday, salary from teacher);
--4.更新
update teacher set salary = salary+200;
commit;
--5.查询
select id, name, birthday, salary from teacher;
--6.删除
delete from teacher;
commit;
--8.删表
drop table teacher;