db_conn.java

动画素材图像语义标注系统：该系统实现对图片的语义标注

package cn.dxm.client;

import java.io.PrintWriter;
import java.sql.*;

public class DB_Conn {
	
	private  String driverName="com.mysql.jdbc.Driver";      //驱动程序名
	private  String userName="root";                         //数据库用户名
	private  String userPwd="root";                        //密码
    private  String dbName="img";                        //数据库名
    private  String url="jdbc:mysql://localhost/"+dbName+
                    "?user="+userName+"&password="+userPwd+
                    "&useUnicode=true&characterEncoding=gb2312";    //连接字符串
    private  Connection conn=null;                          //数据库连接对象
    public Statement sm=null;                               //数据库语句对象
    private PrintWriter out = null;
    
    // 建立数据库连接
    public void ConnectDB(){
    	 try {
    		 Class.forName(driverName).newInstance();
        	 conn=DriverManager.getConnection(url);  //获得数据库连接
        	 sm=conn.createStatement();
         } catch(Exception e) {
    		 e.printStackTrace();		 
        	 out.print("数据库连接失败!");
    	 }
    }
    
    public void CloseDB(){
    	try {
			if (sm != null) {
				sm.close();
			}
			conn.close();
		} catch (SQLException SqlE) {
			SqlE.printStackTrace();
			out.print("数据库关闭失败！");
		}
    
   }
}