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
相关文档:
Here is a simple library to query Google Maps with the following features:
geocode addresses to their geographic coordinates
retrieve static images with given custom size, format and zoom
To see a live sample of this API, you can check here: Java ME Google Maps API sample MIDlet
Contents
[h ......
JAVA操作XML的完整例子——W3C DOM
JAVA操作XML的完整例子——W3C DOM篇收藏
这是一个用JAVA W3C DOM 进行XML操作的例子,包含了查询、增加、修改、删除、保存的基本操作。较完整的描述了一个XML的整个操作流程。适合刚入门JAVA XML操作的朋友参考和学习。
假设有XML文件:test1.xml
<?xml v ......
亲爱的 Java 新手们:
很高兴你们愿意来这里共同学习,
Java 这个语言,已经不再是语言了,他勾勒出一个开放式的开发环境,
基本上 java.sum.com 很粗略地把 Java 分为三个部分:
(1) J2SE ( Java 2 Standard Edition )
(2) J2EE ( Java 2 Enterprise Edition )
(3) J2ME ( Java 2 Micro Edition ) ......
Ubuntu Linux Install Sun Java Development Kit ( JDK ) and Java Runtime Environment ( JRE )
by Vivek Gite
Q.
How do I install Sun
Java Development Kit (JDK) and Java Runtime Environment (JRE) under
Ubuntu Linux? It appears that there are multiple JRE installed by
default under Ubuntu. ......
创建数据库:
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 ......