Java+Mysql的数据库查找实现
public class select {
public List XiuGai_select(String keyword){
List list=new ArrayList();
Connection conn = null;
Statement stmt = null;
String sql=null;
ResultSet res = null;
getConnection b=new getConnection();
conn=b.getconnection();
sql="select * from book where bookName like'%"+keyword+"%'";
try {
stmt = conn.createStatement();
res=stmt.executeQuery(sql);
while (res.next()) { //如果结果集不为空，那么取出值输出
int id = res.getInt("id");
String bookName= res.getString("bookName");
String author= res.getString("author");
String publisher= res.getString("publisher");
int isBorrow=res.getInt("isBorrow");
int isRenew=res.getInt("isRenew");
Date dateOfBorrow=res.getDate("dateOfBorrow");
int numberOfBook=res.getInt("numberOfBook");
int numberOfNow=res.getInt("numberOfNow");
int userId=res.getInt("userId");
Book book = new Book(id,bookName,author,publisher,isBorrow,isRenew,dateOfBorrow,numberOfBook,numberOfNow,userId);
list.add(book);
System.out.println(id);
System.out.println(b
相关文档：
1. 概述
本文主要包括以下几个方面：编码基本知识，java，系统软件，url，工具软件等。
在下面的描述中，将以"中文"两个字为例，经查表可以知道其GB2312编码是"d6d0 cec4"，Unicode编码为"4e2d 6587"，UTF编码就是"e4b8ad e69687"。注意，这两个字没有iso8859-1编码，但可以用iso8859-1编码来"表示"。
2. 编码基本知� ......
package com.navinfo.mygim.admin.util;
/*
* Pinyin.java
* vicbay
*/
public class Pinyin{
private String[] name = { "zuo", "zun", "zui", "zuan", "zu", "zou",
"zong", ......
/*
* @(#)MemoryMonitor.java 1.3 05/11/17
*
* Copyright (c) 2006 Sun Microsystems, Inc. All Rights Reserved.
*
* Redistribution and use in source and binary forms, with or without
* modification, are permitted provided that the following conditions are ......
创建数据库：
mysql>create database test;
Query OK, 1 row affected (0.02 sec)
创建数据库表：
mysql>use test;
Database changed
创建数据库表：
myaql>create table user(SID VARCHAR(11), name VARCHAT(6) );
Query OK, 0 rows affected (0.08 sec)
插入记录：
mysql>insert int use ......
