关于JAVA和数据库连接

来源：百度知道 编辑：UC知道 时间：2024/05/12 20:03:48
import java.sql.*;

/**
访问数据库的一个简单例子
*/
public class TestDB
{
public static void main (String args[])
{
try
{
connectDatabase();
}
catch (SQLException ex)
{
ex.printStackTrace();
}
}

public static void connectDatabase() throws SQLException
{
Connection conn=null;
try
{
System.setProperty("jdbc.drivers", "com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databasename=address", "sa","1414789");
Statement stat = conn.createStatement();
String sql="select bookId,bookName,publisher from book";
ResultSet result=stat.executeQuery(sql);

while(result.next())
{
System.out.

你的try 没有对应的catch

你在main里catch了 但是在下面的方法没有catch 有try没有catch的话 格式是错的 有try就必须有catch

public static void connectDatabase() throws SQLException
{
Connection conn=null;
try
{
System.setProperty("jdbc.drivers", "com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databasename=address", "sa","1414789");
Statement stat = conn.createStatement();
String sql="select bookId,bookName,publisher from book";
ResultSet result=stat.executeQuery(sql);

while(result.next())
{
System.out.println(result.getInt("bookId"));
System.out.println(result.getString("bookName"));
System.out.println(result.getString("publisher"));
}
//result.close();
//stat.close();
}
catch (SQLException ex)
{
ex.printStackTrace();