1 sql语句 where条件处理
public ResultSet bookTypeList(Connection con,BookType bookType) throws Exception{
StringBuffer sb=new StringBuffer("select * from t_bookType");
if(StringUtil.isNotEmpty(bookType.getBookTypeName())){
sb.append(" and bookTypeName like '%"+bookType.getBookTypeName()+"%'");
}
//可以加多个条件
PreparedStatement pstmt=con.prepareStatement(sb.toString().replaceFirst("and", "where"));
return pstmt.executeQuery();
}
2 //改变系统默认字体
Font font = new Font("Dialog", Font.PLAIN, 12);
java.util.Enumeration keys = UIManager.getDefaults().keys();
while (keys.hasMoreElements()) {
Object key = keys.nextElement();
Object value = UIManager.get(key);
if (value instanceof javax.swing.plaf.FontUIResource) {
UIManager.put(key, font);
}
}
3 通过鼠标事件选择行 JTABLE
private void bookTypeTableMousePressed(java.awt.event.MouseEvent evt) {
// 获取选中的行
int row = bookTypeTable.getSelectedRow();
this.idTxt.setText((String) bookTypeTable.getValueAt(row, 0));
this.bookTypeNameTxt.setText((String) bookTypeTable.getValueAt(row, 1));
this.bookTypeDescTxt.setText((String) bookTypeTable.getValueAt(row, 2));
}
public ArrayList getBook()
{
ArrayList<Book> newal=new ArrayList<Book>();
String sql="select * from book where 1=?";
String [] para={"1"};
ArrayList al=new SQLHepler().executeQuery3(sql, para);
for(int i=0;i<al.size();i++)
{ Book book=new Book();
Object [] obj=(Object[]) al.get(i);
book.setId(Integer.parseInt(obj[0].toString()));
book.setName(obj[1].toString());
book.setAuthor(obj[2].toString());
book.setPublishHouse(obj[3].toString());
book.setPrice(Float.parseFloat(obj[4].toString()));
book.setNums(Integer.parseInt(obj[5].toString()));
newal.add(book);
}
4 遍历字符串的每一个汉字
boolean matches=Pattern.matches("[\u4E00-\u9FA5]{0,}$",text.charAt(i)+"");