conmanager.java

用Java实现学生成绩管理系统的crud功能

package cn.com.dao;

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

public class ConManager {
	 public static	Connection conn=null;
	 public   static  Statement stmt=null;
	 public static    ResultSet rs=null;
public static  Connection getConnection(){
	try {
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	} catch (InstantiationException e) {
	e.printStackTrace();
	} catch (IllegalAccessException e) {
	e.printStackTrace();
	} catch (ClassNotFoundException e) {
	e.printStackTrace();
	}
	try {
	conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/school","root","root");
	stmt=conn.createStatement();
	} catch (SQLException e) {
		e.printStackTrace();
	}
	return conn;	

}
	

}