62,614
社区成员
发帖
与我相关
我的任务
分享
if(e.getKeyCode()==KeyEvent.VK_ENTER){
System.out.println("按下Enter键");
press();
private void press() {
String goodsinput = JTi.getText().trim();
String []paras={"%"+goodsinput+"%","%"+goodsinput+"%"};
String sql = "SELECT * from goods where GoodsID like ? or GoodsName like ?";
condb con = new condb();
try {
con.opensql();
ResultSet rs=con.selectsql(sql,paras);
if(rs.next()){
String[]temp=new String[10];
for (int i = 0; i < 10; i++) {
temp[i]=rs.getString(i+1);
System.out.print(temp[i]+" ");
}
System.out.println("");
public ResultSet selectsql(String sql,String [] paras){
//System.out.println (sql);
try {
pstat=con.prepareStatement(sql);
for(int i=0;i<paras.length;i++){
pstat.setString(i+1,paras[i]);
System.out.println (paras[i]);
}
rs=pstat.executeQuery();
System.out.println (pstat.toString());
System.out.println ("select ok");
}
catch (Exception ex) {
private void press() {
String goodsinput = JTi.getText().trim();
String []paras={"%"+goodsinput+"%","%"+goodsinput+"%"};
String sql = "SELECT * from goods where GoodsID like '?' or GoodsName like '?'";
//String sql = "SELECT * from goods where GoodsID like '%"+goodsinput+"%' or GoodsName like '%"+goodsinput+"%'";
condb con = new condb();
try {
con.opensql();
//ResultSet rs=con.selectsql(sql);
ResultSet rs=con.selectsql(sql,paras);
按下Enter键
open sql successed!
java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.clearParameter(JdbcOdbcPreparedStatement.java:1022)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setChar(JdbcOdbcPreparedStatement.java:3056)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setString(JdbcOdbcPreparedStatement.java:765)
at db.condb.selectsql(condb.java:111)
at show.sellWim.press(sellWim.java:253)
at show.sellWim.keyReleased(sellWim.java:228)
空指针异常了[/quote]
String []paras={goodsinput,goodsinput};
String sql = "SELECT * from goods where GoodsID like \'%?%\' or GoodsName like\'%?%\' '";[/quote]
还是空指针异常
private void press() {
String goodsinput = JTi.getText().trim();
String []paras={goodsinput,goodsinput};
//String []paras={"%"+goodsinput+"%","%"+goodsinput+"%"};
String sql = "SELECT * from goods where GoodsID like \'%?%\' or GoodsName like \'%?%\'";
//String sql = "SELECT * from goods where GoodsID like '%"+goodsinput+"%' or GoodsName like '%"+goodsinput+"%'";
condb con = new condb();
try {
con.opensql();
//ResultSet rs=con.selectsql(sql);
ResultSet rs=con.selectsql(sql,paras);
if(rs.next()){
String[]temp=new String[10];
for (int i = 0; i < 10; i++) {
temp[i]=rs.getString(i+1);
System.out.print(temp[i]+" ");
}
System.out.println("");
}else{
JOptionPane.showMessageDialog(this, "无此商品!","提示",JOptionPane.WARNING_MESSAGE);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
con.closesql();
}
}
private void press() {
String goodsinput = JTi.getText().trim();
String []paras={"%"+goodsinput+"%","%"+goodsinput+"%"};
String sql = "SELECT * from goods where GoodsID like '?' or GoodsName like '?'";
//String sql = "SELECT * from goods where GoodsID like '%"+goodsinput+"%' or GoodsName like '%"+goodsinput+"%'";
condb con = new condb();
try {
con.opensql();
//ResultSet rs=con.selectsql(sql);
ResultSet rs=con.selectsql(sql,paras);
按下Enter键
open sql successed!
java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.clearParameter(JdbcOdbcPreparedStatement.java:1022)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setChar(JdbcOdbcPreparedStatement.java:3056)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setString(JdbcOdbcPreparedStatement.java:765)
at db.condb.selectsql(condb.java:111)
at show.sellWim.press(sellWim.java:253)
at show.sellWim.keyReleased(sellWim.java:228)
空指针异常了[/quote]
String []paras={goodsinput,goodsinput};
String sql = "SELECT * from goods where GoodsID like \'%?%\' or GoodsName like\'%?%\' '"; try {
con.opensql();
//ResultSet rs=con.selectsql(sql);
ResultSet rs=con.selectsql(sql,paras);
if(rs.next()){
String[]temp=new String[10];
for (int i = 0; i < 10; i++) {
temp[i]=rs.getString(i+1);
System.out.print(temp[i]+" ");
}
System.out.println("");
}else{
JOptionPane.showMessageDialog(this, "无此商品!","提示",JOptionPane.WARNING_MESSAGE);
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}finally{
con.closesql();
}
运行完selectsql方法之后单独都方法关库 private void press() {
String goodsinput = JTi.getText().trim();
String []paras={"%"+goodsinput+"%","%"+goodsinput+"%"};
String sql = "SELECT * from goods where GoodsID like '?' or GoodsName like '?'";
//String sql = "SELECT * from goods where GoodsID like '%"+goodsinput+"%' or GoodsName like '%"+goodsinput+"%'";
condb con = new condb();
try {
con.opensql();
//ResultSet rs=con.selectsql(sql);
ResultSet rs=con.selectsql(sql,paras);
按下Enter键
open sql successed!
java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.clearParameter(JdbcOdbcPreparedStatement.java:1022)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setChar(JdbcOdbcPreparedStatement.java:3056)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setString(JdbcOdbcPreparedStatement.java:765)
at db.condb.selectsql(condb.java:111)
at show.sellWim.press(sellWim.java:253)
at show.sellWim.keyReleased(sellWim.java:228)
空指针异常了String goodsinput = JTi.getText().trim();
String []paras={goodsinput,goodsinput};
//String []paras={"%"+goodsinput+"%","%"+goodsinput+"%"};
//String sql = "SELECT * from goods where GoodsID like \'%?%\' or GoodsName like \'%?%\'";
String sql = "SELECT * from goods where GoodsID like '%"+goodsinput+"%' or GoodsName like '%"+goodsinput+"%'";