querydata.java

jfreechart 柱状图 均值图 和值图 实例

package com.query;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Vector;

public class QueryData {
	private String driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver";
	
	private String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=voipswitch";

	private String username = "ttt";

	private String password = "123";
	
	Connection con;
	
	public QueryData(){
		try {
			Class.forName(driverClassName);
			con=DriverManager.getConnection(url,username,password);
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
	public Vector query(){
		Vector<Employee> v=new Vector<Employee>();
		PreparedStatement ps=null;
		ResultSet rs=null;
		String sql="select employeeid,employeename from pub_employee";
		try {
			ps=con.prepareStatement(sql);
			rs=ps.executeQuery();
			int i = 0;
			while(rs.next()){
				Employee e=new Employee();
				e.setEmployeeid(rs.getString("employeeid"));
				e.setEmployeename(rs.getString("employeename"));
				v.add(i, e);
				i++;
			}
			ps.close();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (ps != null)
					ps.close();
				if (con != null)
					con.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return v;
	}
	//保存
	public void dosave(Employee emp) {
		String employeeid = emp.getEmployeeid();
		String employeename = emp.getEmployeename();
		PreparedStatement ps=null;
		try {
			String sql = "insert into pub_employee(employeeid,employeename) values(?,?)";
			ps=con.prepareStatement(sql);
			ps.setString(1, employeeid);
			ps.setString(2, employeename);
			ps.execute();
			ps.close();
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			try {
				if (ps != null)
					ps.close();
				if (con != null)
					con.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}

	}
	public static void main(String[] args){
		QueryData qd=new QueryData();
		Vector<Employee> v=qd.query();
		for(int i = 0 ; i<v.size();i++){
			Employee e =v.get(i);
			System.out.println(e.getEmployeeid()+"--->"+e.getEmployeename());
		}
	}
}