To access database by javabean

Former Member · ‎02-21-2007

Hi,

I create new java program and jar it to jar file, then I import this jar file as the model.

I try this program in normal jdk, it is no problem. But when I use it as the model, I encounter the exclamation after the deployment and run.

My program is as the following.

Can't I put the connection statement in the construction ?package com.sun;

-

package com.sun;

import java.math.BigDecimal;

import java.sql.*;

public class EmpBean{

private int empno;

private String ename = "";

private String job = "";

private int mgr;

private double sal;

private double comm;

private int deptno;

private Connection conn = null;

private Statement stmt = null;

public EmpBean(){

try {

this.conn = getConnection();

this.stmt = conn.createStatement();

String sql = "SELECT * FROM user1";

ResultSet result = stmt.executeQuery(sql);

if(result.next()){

this.ename = result.getString("name");

}

} catch (SQLException e) {

this.ename="ex1";

e.printStackTrace();

}

finally {

if(stmt != null) {

try {

stmt.close();

}

catch(SQLException e) {

this.ename="ex2";

e.printStackTrace();

}

if(conn != null) {

try {

conn.close();

}

catch(SQLException e) {

this.ename="ex3";

e.printStackTrace();

}

/*

*

public EmpBean(){

try {

this.conn = getConnection();

this.stmt = conn.createStatement();

String sql = "SELECT * FROM user1";

ResultSet result = stmt.executeQuery(sql);

if(result.next()){

this.ename = result.getString("name");

}

} catch (SQLException e) {

e.printStackTrace();

}

finally {

if(stmt != null) {

try {

stmt.close();

}

catch(SQLException e) {

e.printStackTrace();

}

if(conn != null) {

try {

conn.close();

}

catch(SQLException e) {

e.printStackTrace();

}

*/

public int getEmpno() {

this.empno=23701;

return this.empno;

}

public void setEmpno(int inValue) {

inValue=23701;

empno = inValue;

}

public String getEname() {

return this.ename;

}

public void setEname(String inValue) {

if (inValue != null)

this.ename = inValue;

}

public String getJob() {

this.job="engineer";

return this.job;

}

public void setJob(String inValue) {

inValue="inValue";

if (inValue != null)

this.job = inValue;

}

public int getMgr() {

this.mgr=22;

return this.mgr;

}

public void setMgr(int inValue) {

mgr = inValue;

}

public double getSal() {

return this.sal;

}

public void setSal(double inValue) {

inValue=10000.00;

sal = inValue;

}

public double getComm() {

this.comm=5.0;

return this.comm;

}

public void setComm(double inValue) {

comm = inValue;

}

public int getDeptno() {

return this.deptno;

}

public void setDeptno(int inValue) {

deptno = inValue;

}

/* public void setAttributes(ResultSet rs)

throws SQLException {

setEmpno(rs.getInt("EMPNO"));

setEname(rs.getString("ENAME"));

setJob(rs.getString("JOB"));

setMgr(rs.getInt("MGR"));

//setHiredate(rs.getDate("HIREDATE"));

setSal(rs.getDouble("SAL"));

setComm(rs.getDouble("COMM"));

setDeptno(rs.getInt("DEPTNO"));

}

public String insertStatement() {

String str = "INSERT INTO EMP (EMPNO,ENAME,JOB,MGR,SAL,COMM,DEPTNO) VALUES (?,?,?,?,?,?,?,?)";

return str;

}

public void insertDatabase(Connection conn)

throws SQLException {

PreparedStatement ps = null;

try {

ps = conn.prepareStatement(insertStatement());

ps.setInt(1, getEmpno());

ps.setString(2, getEname());

ps.setString(3, getJob());

ps.setInt(4, getMgr());

// ps.setDate(5, getHiredate());

ps.setDouble(6, getSal());

ps.setDouble(7, getComm());

ps.setInt(8, getDeptno());

ps.executeUpdate();

} finally {

if (ps != null) {

try {

ps.close();

ps = null;

} catch(SQLException e) {}

}

*/

private static Connection getConnection() {

String DRIVER = "oracle.jdbc.OracleDriver";

String iURL = "jdbc:oracle:thin:@botstdb1:1521:dev9utf8";

String USER = "icmr2p";

String PASSWD = "icmr2p";

try {

Class.forName(DRIVER);

} catch (ClassNotFoundException e) {

System.out.println("找不到JDBC驅動程式");

e.printStackTrace();

}

Connection conn = null;

try {

conn = DriverManager.getConnection(iURL, USER, PASSWD);

} catch (SQLException e) {

e.printStackTrace();

}

return conn;

}

Former Member · ‎02-21-2007

I found the nullpoint exception in two lines.

this.conn = getConnection();

this.stmt = conn.createStatement();

Former Member · ‎02-21-2007

Hi,

I feel Exclamation is just a warning...Are you getting any exceptions ??

If so post the exception.

Regards,Anilkumar

To access database by javabean

Accepted Solutions (0)

Answers (2)

Answers (2)

Custom Fields for Goods Receipt Label

Re: Struggling with Filters on Select - Fiori App

Re: Struggling with Filters on Select - Fiori App

Re: Struggling with Filters on Select - Fiori App

Re: Struggling with Filters on Select - Fiori App