怎样用JAVA语言建自己想要的数据库

发布网友

我来回答

共2个回答

热心网友

只要把数据库的连接写好了，自己写增删改查就好了。+
jdbc数据库连接
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class Database
{
public Connection conn = null;
private String url =
"jdbc:microsoft:sqlserver://localhost:1433;databaseName=test";
private String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private String user = "sa";
private String pwd = "";
boolean flag;

// 加载驱动
public Database() throws Exception
{
try
{
Class.forName(driver);
}
catch (Exception ex)
{
ex.printStackTrace();
throw ex;
}
}

// 连接数据库
public void getConn() throws Exception
{
try
{
if (conn == null || conn.isClosed())
{
this.conn = DriverManager.getConnection(url, user, pwd);
}
}
catch (Exception ex)
{
ex.printStackTrace();
throw ex;
}
}

// 关闭conn
public void closeConn(Connection conn)
{
if (conn != null)
{
try
{
conn.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}

//关闭ps
public void closePs(PreparedStatement ps)
{
if (ps != null)
{
try
{
ps.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}

// 关闭rs
public void closeRs(ResultSet rs)
{
if (rs != null)
{
try
{
rs.close();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}

// 查询

public void getStu() throws Exception
{
PreparedStatement ps = null;
ResultSet rs = null;
try
{
this.getConn();
ps = this.conn.prepareStatement("select * from student");
rs = ps.executeQuery();

while (rs.next())
{
System.out.println(rs.getLong(1));
System.out.println(rs.getString(2));
System.out.println(rs.getLong(3));
System.out.println(rs.getString(4));
System.out.println(rs.getString(5));
}

}
catch (Exception ex)
{
ex.printStackTrace();
throw ex;
}

finally
{
if (rs != null)
{
this.closeRs(rs);
}
if (ps != null)
{
this.closePs(ps);
}
if (conn != null)
{
this.closeConn(conn);
}
}
}
}

热心网友

数据库不是JAVA语言建的,要实现你说的功能,你要装相关的数据库软件,用数据库软件建立你说的数据库,数据库里保存了你要保存的信息.让后用JAVA来编写应用程序,实现你说的查找,更新数据的功能,上面那兄弟写的代码就是这些功能的实现.你要写具体的代码来调用他写的代码,就可以实现你说的简单功能了.