testalterttable.java#1.1.1.1

来自「数据库远程同步软件NetBeans项目源文件 项目采用Jdesktop集成组件」· 1 代码 · 共 34 行

package com.qixuan.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

import com.qixuan.jdbc.util.ALTERTablesUtil;

public class TestAltertTable {
	public static void main(String[] args) {
		Connection connection = null;
		PreparedStatement pstmt = null;
		Statement stm=null;
		try {
			Class.forName("com.mysql.jdbc.Driver");
			connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/diims_1?autoReconnect=true","root","admin123");
			/*
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			connection = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databaseName=bpoms;selectMethod=cursor;","forever","admin123");
			Class.forName("org.postgresql.Driver");
			connection = DriverManager.getConnection("jdbc:postgresql://localhost/diims","postgres","admin123");*/
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}		
		ALTERTablesUtil.AddColumnByRecordFlag(connection);
	}
}