JDBC连接oracle数据库

要写完很费劲啊，就给你写一个增加记录吧。
为了测试 先要加一个实体类，
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 dao=new TeacherDao();
dao.add(vo);
}

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/y2yxeyj3j.html