savetodatabase.java

一款少见的用swt写的彩票软件

package com.dc.system;

import java.sql.Connection;
import java.sql.PreparedStatement;

import com.dc.db.RdbmsConnecter;
import com.dc.win.MessageBoxShow;


public class SaveToDatabase {
	public void SaveSelection(String red_data1,String red_data2,
			String red_data3,String red_data4,String red_data5,
			String red_data6,String blue_data) throws Exception {
		String sql = "insert into data values (?,?,?,?,?,?,?)";
		Connection con = RdbmsConnecter.getInstance().getConnection();
		try {
			PreparedStatement ps = con.prepareStatement(sql);
			ps.setString(1, red_data1);
			ps.setString(2, red_data2);
			ps.setString(3, red_data3);
			ps.setString(4, red_data4);
			ps.setString(5, red_data5);
			ps.setString(6, red_data6);
			ps.setString(7, blue_data);
			ps.execute();
			MessageBoxShow msg = new MessageBoxShow("投注成功!","提示");
			msg.start();
		} catch (Exception e) {
			e.printStackTrace();
		}finally{
			if(con!=null){
				con.close();
			}
		}
	}
}