package com.jdbc.model;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JDBCModel {
/**
* @param args
* @throws SQLException
*/
public static void main(String[] args) throws SQLException {
temple();
}
static void temple() throws SQLException{
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
//利用工具类注册驱动,建立与mysql的连接
conn = JdbcUtil.getConnection();
//创建连接语句
stmt = conn.createStatement();
String insertsql = "insert into person(name,gender,birth) values('老朱','男','1986-1-1')";
String querysql = "select * from person";
//执行插入语句
stmt.executeUpdate(insertsql);
//执行查询语句
rs = stmt.executeQuery(querysql);
//处理结果
while(rs.next()){
System.out.println("-----------------------------------");
System.out.println("记录"+rs.getString("id")+
"\t姓名:"+rs.getString("name")+"\n"+
"\t性别:"+rs.getString("gender")+"\n"+
"\t出生年月:"+rs.getString("birth"));
}
} catch (SQLException e) {
e.printStackTrace();
}finally{
//释放资源
JdbcUtil.free(conn, stmt, rs);
}
}
}
|
package com.jdbc.model;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public final class JdbcUtil {
private static String url ="jdbc:mysql://localhost:3306/mysqltest?&useUnicode=true&characterEncoding=UTF-8";
private static String user = "root";
private static String password = "123456";
private JdbcUtil(){}
//注册驱动
static {
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
//抛出异常,提示出错
throw new ExceptionInInitializerError();
}
}
//建立连接
public static Connection getConnection() throws SQLException{
return DriverManager.getConnection(url,user,password);
}
//释放资源
public static void free(Connection conn,Statement stmt,ResultSet rs){
try{
if(rs!=null)
rs.close();
} catch(SQLException e){
e.printStackTrace();
}finally{
try{
if(stmt!=null)
stmt.close();
}catch(SQLException e){
e.printStackTrace();
}finally{
if(conn!=null)
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
}
}
|
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`id` int(2) NOT NULL auto_increment,
`name` char(4) default NULL,
`gender` char(2) default NULL,
`birth` date default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
|
package com.moonights.demo.jfreechart;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartUtilities;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.plot.CategoryPlot;
import org.jfree.chart.plot.PlotOrientation;
import org.jfree.data.category.CategoryDataset;
import org.jfree.data.general.DatasetUtilities;
//JFreeChart Bar Chart(柱状图)
public class CreateJFreeChartBar {
/**
* 创建JFreeChart Bar Chart(柱状图)
*/
public static void main(String[] args) {
//步骤1:创建CategoryDataset对象(准备数据)
CategoryDataset dataset = createDataset();
//步骤2:根据Dataset 生成JFreeChart对象,以及做相应的设置
JFreeChart freeChart = createChart(dataset);
//步骤3:将JFreeChart对象输出到文件,Servlet输出流等
saveAsFile(freeChart, "c:\\jfreechart\\bar.png", 500, 400);
}
//保存为文件
public static void saveAsFile(JFreeChart chart, String outputPath, int weight, int height) {
FileOutputStream out = null;
try {
File outFile = new File(outputPath);
if (!outFile.getParentFile().exists()) {
outFile.getParentFile().mkdirs();
}
out = new FileOutputStream(outputPath);
//保存为PNG文件
ChartUtilities.writeChartAsPNG(out, chart, 300, 200);
//保存为JPEG文件
//ChartUtilities.writeChartAsJPEG(out, chart, 500, 400);
out.flush();
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
if (out != null) {
try {
out.close();
} catch (IOException e) {
//do nothing
}
}
}
}
//根据CategoryDataset生成JFreeChart对象
public static JFreeChart createChart(CategoryDataset categoryDataset) {
JFreeChart jfreechart = ChartFactory.createBarChart("Bar Chart Demo", //标题
"产品", //categoryAxisLabel (category轴,横轴,X轴的标签)
"数量", //valueAxisLabel(value轴,纵轴,Y轴的标签)
categoryDataset, // dataset
PlotOrientation.VERTICAL,
true, // legend
false, // tooltips
false); // URLs
//以下的设置可以由用户定制,也可以省略
CategoryPlot plot = (CategoryPlot) jfreechart.getPlot();
//背景色 透明度
plot.setBackgroundAlpha(0.5f);
//前景色 透明度
plot.setForegroundAlpha(0.5f);
//其它设置可以参考 CategoryPlot
return jfreechart;
}
/**
* 创建CategoryDataset对象
*
*/
public static CategoryDataset createDataset() {
String []rowKeys = {"One", "Two", "Three"};
String []colKeys = {"1987", "1997", "2007"};
double [][] data = {
{50, 20, 30},
{20, 10D, 40D},
{40, 30.0008D, 38.24D},
};
//也可以使用以下代码
//DefaultCategoryDataset categoryDataset = new DefaultCategoryDataset();
//categoryDataset.addValue(10, "rowKey", "colKey");
return DatasetUtilities.createCategoryDataset(rowKeys, colKeys, data);
}
}
|