package com.fr.tx.common.util;

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




public class DbConnect {

 
	private String url;

	public DbConnect(String url){
		this.url = url;
	}
	
	public void getDbSource() {
		try {
			Class.forName("com.mysql.jdbc.Driver");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
//		String url="jdbc:mysql://localhost:8080/gdzy?user=root&password=root";
		Connection conn;
		try {
			conn = DriverManager.getConnection(url);
			Statement stmt = conn.createStatement();
			String sql = "insert into StudInfo(name, passw) values('zhangsan', '123');";
			stmt.executeUpdate(sql);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		
	}
	
	public String getUrl() {
		return url;
	}

	public void setUrl(String url) {
		this.url = url;
	}

   

}