sqlconnecttest.java

来自「一款少见的用swt写的彩票软件」· Java 代码 · 共 44 行

/*
 * Created on 2008-9-26
 *
 * Copyright Digital China Co. Ltd.
 * All right reserved.
 *
 *
 *
 */


package com.dc.db;

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

public class SqlConnectTest {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		String sql = "insert into data values (?,?,?,?,?,?,?)";
		Connection con = RdbmsConnecter.getInstance().getConnection();
		if(con == null){
			System.out.println("找不到驱动器");
		}
		try {
			PreparedStatement ps = con.prepareStatement(sql);
			ps.setInt(1, 03);
			ps.setInt(2, 07);
			ps.setInt(3, 14);
			ps.setInt(4, 21);
			ps.setInt(5, 29);
			ps.setInt(6, 32);
			ps.setInt(7, 13);
			ps.execute();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}