?? publishers.java
字號:
package booksys;
import java.sql.*;
public class publishers{
int publisherid;
String publishernm;
String address1;
String address2;
String country;
String phone;
boolean newpublisher;
public publishers(){
}
public static int searchid(String publishernm) throws Exception{
dbconn.conn();
int result;
String sql = "select publisherid from publishers where publishernm='"+publishernm+"'";
ResultSet rs = dbconn.dbquery(sql);
if(rs.next()){
result=rs.getInt(1);
}
else{
result=0;
}
dbconn.dbclose();
return result;
}
public static String searchnm(int id) throws Exception{
dbconn.conn();
String s="";
String sql = "select publishernm from publishers where publisherid="+id;
ResultSet rs = dbconn.dbquery(sql);
if(rs.next()){
s = rs.getString(1).trim();
}
return s;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -