import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
public class DBHelper
{
private static final String DB_URL = “jdbc:kingbase8://127.0.0.1:54321/test”;
private static final String USERNAME = “SYSTEM”;
private static final String PASSWORD = “123456”;
private static Connection conn = null;
public static Connection getConnection() throws Exception
{
if( conn == null )
{
DriverManager.registerDriver( new com.kingbase8.Driver() );
conn = DriverManager.getConnection( DB_URL, USERNAME, PASSWORD );
return conn;
}
return conn;
}
public static void queryErtu() throws Exception
{
String str_sql = “select * from a”;
conn = getConnection();
try
{
PreparedStatement pst = conn.prepareStatement( str_sql );
ResultSet ret = pst.executeQuery();
while( ret.next() )
{
System.out.println( ret.getString(1) + “:” + ret.getString(2) + “:” + ret.getString(3) );
}
ret.close();
} catch (Exception e)
{
e.printStackTrace();
}
}
public static void main(String[] args) throws Exception
{
try
{
Connection conn = DBHelper.getConnection();
if( conn != null )
System.out.println(“数据库连接正常!”);
else
System.out.println(“数据库连接失败!”);
} catch (Exception e)
{
e.printStackTrace();
}
queryErtu();
}
}
kingbase 配置jdbc访问
最新推荐文章于 2024-06-06 18:05:40 发布