storehouseconnection.java

来自「仓库管理」· Java 代码 · 共 55 行

package com.store.common;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import com.store.entity.Student;


public class StoreHouseConnection 
{
	
	
	public Connection getConnection()
	{
		Connection con=null;
		try
		{
		  Class.forName("com.mysql.jdbc.Driver");
		  con=DriverManager.getConnection("jdbc:mysql://localhost:3306/master","root","111");
		  
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return con;
	}
	public ArrayList getStuList(String temp)
	{
		ArrayList lst=new ArrayList();
		try
		{
			Connection con=this.getConnection();
			Statement st=con.createStatement();
			ResultSet rs=st.executeQuery("select * from stu where stuname like '"+temp+"%'");
			while(rs.next())
			{
				Student s=new Student();
				s.setStuId(rs.getInt(1));
				s.setStuName(rs.getString(2));
				lst.add(s);
			}
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		return lst;
	}
	
}