dbutil.java

学生信息管理系统

package bbs.bean;

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

public class DBUtil
{
	/**
	 * 获得数据库连接Connection
	 * @return
	 * @throws SQLException
	 */
	public static Connection getConn()throws SQLException
	{
		Connection conn = null;
		Properties props = new Properties();
		props.put("user", "user1");
		props.put("password", "user1");
        
		conn = DriverManager.getConnection("jdbc:derby:bbs", props);
		return conn;
	}
	
	/**
	 * 创建数据库表
	 *
	 */
	public static void createTable()
	{
		Connection conn = null;
		Properties props = new Properties();
		props.put("user", "user1");
		props.put("password", "user1");
		
		try
        {
        	//建立数据库连接的同时创建库"bbs"
			conn = DriverManager.getConnection("jdbc:derby:bbs;create=true", props);

			System.out.println("连接并建立数据库bbs成功");
            
			Statement stmt = conn.createStatement();
            
            //用户IP表
			String slq_create = "create table msg(" +
			"id int GENERATED ALWAYS AS IDENTITY, " +	//自增ID
			"parentId int," +							//父贴id，新贴的父贴id是0
    		"subject varchar(255)," +					//帖子标题
    		"content varchar(32672)," +					//帖子内容
    		"sendTime TIMESTAMP," +						//发帖时间
    		"sender varchar(16)," +						//发贴人
    		"PRIMARY KEY(id))";							//主键
            
            
			stmt.execute(slq_create);
            //--
			System.out.println("创建msg表成功");
            
            //关闭连接
    		conn.close();
        }
		catch (SQLException e)
        {
        	//--
			e.printStackTrace();
        }
	}
}