dbcon.java

一个网上购物商城系统

package dao;

import java.io.BufferedReader;
import java.io.FileInputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;


public class DBCon {
	private static Connection	con;
	private static String		url="jdbc:mysql://127.0.0.1:3306/xindou?characterEncoding=utf8";
	public static String		user="root";
	public static String		pwd="cd32429";
	
	
	public static Connection getCon(){
		if(con==null){
			try {
				Class.forName("com.mysql.jdbc.Driver");
				con=DriverManager.getConnection(url,user,pwd);
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		return con;
	}
	public static void execute(String sql){
		if(con==null){
			getCon();
		}
		try {
			PreparedStatement pstmt=con.prepareStatement(sql);
			pstmt.execute();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.out.println("sql语法错误");
		}
	}
	
}