test.java

用struts+hibernate实现案例

import java.sql.*;
import java.util.*;
import java.text.*;
import java.io.*;
import java.util.ArrayList;


public class test{
	public ArrayList getData(String name){
		ArrayList list=new ArrayList();
		try{
			TestForm tf;
			String ls_name="%"+name+"%";
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/t1","root", "123456");
			String s="select * from a2 where name like ?";
			PreparedStatement ps=conn.prepareStatement(s);
			ps.setString(1,ls_name);
			ResultSet rs=ps.executeQuery();
			while(rs.next()){
			tf=new TestForm();
			tf.setNo(rs.getInt("no"));
			tf.setName(rs.getString("name"));
			list.add(tf);
			}
			}
			catch(Exception e){
			e.printStackTrace();
			}
			return list;
		
	}
}