求指点。。。
序列插入出问题，求指教。。。
以下是源代码。。。。
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
public class MasterManager {
public boolean login(String loginId, String password) {
boolean ret = false;
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:pet", "epet", "bdqn");
String sqlStr = "select 1 from master where LOGINID = ? and PASSWORD = ? and status = 1";
pstmt = con.prepareStatement(sqlStr);
pstmt.setString(1, loginId);
pstmt.setString(2, password);
rs = pstmt.executeQuery();
if (rs.next()) {
ret = true;
} else {
ret = false;
}
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
if (null != rs) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (null != pstmt) {
pstmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (null != con) {
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
return ret;
}
public void login() {
Scanner input = new Scanner(System.in);
System.out.println("-----欢迎光临宠物乐园-----");
System.out.print("请输入用户名：");
String loginId = input.next();
System.out.print("请输入密码：");
String password = input.next();
if (login(loginId, password)) {
System.out.println("登陆成功！\n");
AdoptPet();
} else {
System.out.println("用户名或密码错误，登陆失败！");
}
}
public void ResultSet() {
Connection con = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:pet", "epet", "bdqn");
StringBuffer sb = new StringBuffer();
sb.append(" select id as 编号,");
sb.append("name as 宠物名,");
sb.append("health as 健康值,");
sb.append("love as 亲密度,");
sb.append("case when status = 1 then '正常' else '禁用' end as 状态,");
sb.append("to_char(adopt_time,'YYYY" + ""年"MM" + ""月" DD"
+ ""日"" + "')");
sb.append(" from pet");
pstmt = con.prepareStatement(sb.toString());
rs = pstmt.executeQuery();
System.out.println("ID\t" + "宠物名\t" + "健康值\t" + "亲密度\t" + "状态\t"
+ "领养时间");
System.out
.println("-------------------------");
while (rs.next()) {
System.out.print(rs.getInt("编号") + "\t");
System.out.print(rs.getString("宠物名") + "\t");
System.out.print(rs.getInt("健康值") + "\t");
System.out.print(rs.getInt("亲密度") + "\t");
System.out.print(rs.getString("状态") + "\t");
System.out.print(rs.getString(6) + "\t");
System.out.println();
}
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
if (null != rs) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (null != pstmt) {
pstmt.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (null != con) {
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public void AdoptPet() {
Scanner input = new Scanner(System.in);
System.out.print("请输入要领养宠物的名字：");
String name = input.next();
System.out.print("请选择要领养宠物的类型：（1、狗狗 2、企鹅）：");
int num = input.nextInt();
InsertPet(name, num);
}
public void InsertPet(String name, int num) {
Connection con = null;
PreparedStatement st = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
con = DriverManager.getConnection(
"jdbc:oracle:thin:@localhost:1521:pet", "epet", "bdqn");
String strSql = "insert into pet(id,master_id,name,type_id,health,love,adopt_time,status) " +
"values(pet_seq.nextval,1,?,?,?,?,?,?)";
st = con.prepareStatement(strSql);
//st.setString(1, "pet_seq.nextval");
//st.setString(2, "master_seq.currval");
st.setString(1, name);
st.setInt(2, num);
st.setInt(3, 100);
st.setInt(4, 0);
st.setString(5, "to_date(to_char(sysdate,'dd-mon-yyyy hh24:mi:ss'),'dd-mon-yyyy hh24:mi:ss'");
st.setInt(6, 1);
System.out.println(strSql);
if (st.execute()) {
System.out.println("领养成功！");
ResultSet();
} else {
System.out.println("领养失败！");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (null != st) {
st.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (null != con) {
con.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
[解决办法]
啥问题？把报错发上来，你意思是让我一句一句读完代码，自己发现问题？
没时间
