jdbc.java

一个基于access数据库开发的简单留言本

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package note;

/**
 *
 * @author xbmu
 */
import java.sql.*;

public class jdbc {

    private static Connection conn = null;
    //String re = "" ;
    //设置你的数据库ip
    //String dbip = "127.0.0.1" ;
    //设置你的数据库用户名和密码：
    private static String use = "";
    private static String pass = "";

    public jdbc() {
    }

    public static Connection getConn() {
        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            //Class.forName("org.gjt.mm.mysql.Driver").newInstance();
            String url = "jdbc:odbc:noteDB";
            //String url ="jdbc:mysql://"+dbip+":3306/"+use+"?user="+use+"&password="+pass+"&useUnicode=true&characterEncoding=gb2312" ;
            conn = DriverManager.getConnection(url, use, pass);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return conn;
    }

    public String ex_chinese(String str) {
        if (str == null) {
            str = "";
        } else {
            try {
                str = new String(str.getBytes("iso-8859-1"), "gb2312");
            } catch (Exception ex) {
                
            }
        }
        return str;
    }

    public String gettime() {
        String datestr = "";
        try {
            java.text.DateFormat df = new java.text.SimpleDateFormat("yyyy年MM月dd日 HH点ss分");
            java.util.Date date = new java.util.Date();
            datestr = df.format(new java.util.Date());
        } catch (Exception ex) {
        }

        return datestr;
    }
}