db.java

这个是一个实用的程序,把数据库中的各个内容整理成一个大的文件!

package cn.yang.novel.db;

import java.sql.*;

import cn.yang.novel.properties.*;

public class Db {

	public Connection getMysqlConnect() throws Exception
	{
		
		String db="mysql";
		String  server = "192.168.1.101";
		String  user = "root";
		String  password = "12345678";
		Class.forName("org.gjt.mm.mysql.Driver").newInstance();
		String arg = "jdbc:mysql://" + server + "/" + db
				+ "?useUnicode=true&characterEncoding=utf-8";
		return DriverManager.getConnection(arg, user, password);

		
	
	}
	public Connection getConnection() {

		String server = Proper.get_SERVER();

		String driver = Proper.get_DRIVER();
		String password = Proper.get_PASSWORD();
		String username = Proper.get_USERNAME();

		Connection conn = null;
		try {
			System.out.println("drive:" + server);
			Class.forName(server).newInstance();

			System.out.println("server:" + driver + ",connecdt...");
			conn = DriverManager.getConnection(driver, username, password);
			System.out.println("connect...ok");
			return conn;

		} catch (Exception e) {
			e.printStackTrace();
			return conn;
		}

	}

	public void close(Connection con) {
		try {
			con.clearWarnings();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}