db 类package insertbean;import java.net.*;
import java.sql.*;
import java.io.*;class db{
Connection conn;
Statement stmt; public void getConnection(){
try{
String driv = "oracle.jdbc.driver.OracleDriver";
Class.forName(driv);
String url = "jdbc:oracle:thin:@localhost:1521:peter";
conn = DriverManager.getConnection(url,"scott","tiger");
System.out.println("已连接到数据库!");
}
catch(Exception e){
System.out.println("出现异常" + e.getMessage());
}
}
public void closeConnection(){
try{
if(conn!=null){
conn.close();
}
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
public boolean executeUpdate(String sql){
try{
getConnection();
if(conn != null){
stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
return true;
}
catch(Exception e){
System.out.println(e.getMessage());
return false;
}
}
}
emp类package insertbean;import java.sql.*;class emp extends db{
private String empno;
private String ename;
public boolean update(){
String sSql = new String("insert into emp(empno,ename)");
sSql = sSql + "values('"+ empno +"','"+ ename + "')";
boolean ret = executeUpdate(sSql);
return ret;
}
public void setename(String en){
ename = en;
}
public void setempno(String em){
empno = em;
}
}testbean类package insertbean;import java.io.*;
import java.sql.*;class testbean{
public static void main(String args[]){
String empno;
String ename;
emp em; try{
System.out.println("请输入工号:");
BufferedReader br= new BufferedReader(new InputStreamReader(System.in));
empno=br.readLine();
System.out.println("请输入姓名:");
br= new BufferedReader(new InputStreamReader(System.in));
ename=br.readLine(); em= new emp();
em.setempno(empno);
em.setename(ename); boolean ret = em.update();
if(ret){
System.out.println("新增记录成功!");
}
else{
System.out.println("新增记录失败!");
}
em.closeConnection();
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
}
运行后
出现异常oracle.jdbc.driver.OracleDriver
新增记录成功!为什么这个插在数据库里没有结果呢
最后显示插入成功
import java.sql.*;
import java.io.*;class db{
Connection conn;
Statement stmt; public void getConnection(){
try{
String driv = "oracle.jdbc.driver.OracleDriver";
Class.forName(driv);
String url = "jdbc:oracle:thin:@localhost:1521:peter";
conn = DriverManager.getConnection(url,"scott","tiger");
System.out.println("已连接到数据库!");
}
catch(Exception e){
System.out.println("出现异常" + e.getMessage());
}
}
public void closeConnection(){
try{
if(conn!=null){
conn.close();
}
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
public boolean executeUpdate(String sql){
try{
getConnection();
if(conn != null){
stmt = conn.createStatement();
stmt.executeUpdate(sql);
}
return true;
}
catch(Exception e){
System.out.println(e.getMessage());
return false;
}
}
}
emp类package insertbean;import java.sql.*;class emp extends db{
private String empno;
private String ename;
public boolean update(){
String sSql = new String("insert into emp(empno,ename)");
sSql = sSql + "values('"+ empno +"','"+ ename + "')";
boolean ret = executeUpdate(sSql);
return ret;
}
public void setename(String en){
ename = en;
}
public void setempno(String em){
empno = em;
}
}testbean类package insertbean;import java.io.*;
import java.sql.*;class testbean{
public static void main(String args[]){
String empno;
String ename;
emp em; try{
System.out.println("请输入工号:");
BufferedReader br= new BufferedReader(new InputStreamReader(System.in));
empno=br.readLine();
System.out.println("请输入姓名:");
br= new BufferedReader(new InputStreamReader(System.in));
ename=br.readLine(); em= new emp();
em.setempno(empno);
em.setename(ename); boolean ret = em.update();
if(ret){
System.out.println("新增记录成功!");
}
else{
System.out.println("新增记录失败!");
}
em.closeConnection();
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
}
运行后
出现异常oracle.jdbc.driver.OracleDriver
新增记录成功!为什么这个插在数据库里没有结果呢
最后显示插入成功
解决方案 »
- 菜鸟--继续报弱智错java.lang.NullPointerException求解!!!
- 请问下列JSP代码在英文系统下如何显示中文??
- 关于JCreato中的JSP
- 急呀
- 更新整理本人所有博文中提供的代码与工具(Java,2013.08)
- 数据权限问题,在线等大神指教,给个解决方案!!!!
- tomcat下servlet的一个问题
- 请问如何利用JAVASCRIPT调用组件
- 关于hibernate的问题
- 讨厌的mm.mysql-2.0.14驱动,高手来看看.
- 写了个javabean,导入到JSP页面时出错,提示无法解析类.....哪位仁兄帮解决了,我把我在CSDN里所有的分数都送给你
- 会myfaces的兄弟进来下
这样executeUpdate()中才能捕捉到。
public void getConnection() throws Exception {
try{
String driv = "oracle.jdbc.driver.OracleDriver";
Class.forName(driv);
String url = "jdbc:oracle:thin:@localhost:1521:peter";
conn = DriverManager.getConnection(url,"scott","tiger");
System.out.println("已连接到数据库!");
}
catch(Exception e){
System.out.println("出现异常" + e.getMessage());
throw new Exception(("出现异常" + e.getMessage())
}
}
getConnection()方法已经抛出异常了呀
况且这句加在这会报错呀