Question

java 连接 数据库 并输出 数据库中的 数据

我是个初学者 就想连接一下数据库试试 哪怕最简单的代码也没关系 数据库名称52moy 里面有student 的表 满意的话 一定高分追加
数据库是sql2000

Answer 1

题目有点不清楚。。

什么数据库啊。。

HI我哈。。我帮你看看。。、

给你写了个例子哈

你需要吧jar包引入到项目里面

如果你没有 我传给你哈

import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

/**
* <p>
* Title:
* </p>
*
* <p>
* Description:
* </p>
*
* <p>
* Copyright: Copyright (c) 2007
* </p>
*
* <p>
* Company:
* </p>
*
* @author not attributable
* @version 1.0
*/
public class SQLServer {
Connection con;

String url;//这个是你的数据库url一般是 jdbc:microsoft:sqlserver://

String serverName;//要连的机器 本机就是localhost

String portNumber;//数据库端口 一般是1433

String databaseName;//数据库名字

String userName;//数据库用户名

String password;//数据库密码

String sql;//sql语句

public SQLServer() {
url = "jdbc:microsoft:sqlserver://";
serverName = "localhost";
portNumber = "1433";
databaseName = "mydb";
userName = "sa";
password = "123";
}

String getConnectionUrl() {
return url + serverName + ":" + portNumber + ";databaseName="
+ databaseName + ";";
}

Connection getConnection() {
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

con = DriverManager.getConnection(getConnectionUrl(), userName,
password);//这里就是连接数据库 url连起来一般都是 jdbc:microsoft:sqlserver://localhost:1433;databaseName=数据库名;
if (con != null) {
System.out.println("连接成功");
}
} catch (Exception e) {
e.printStackTrace();
}
return con;
}

void display() {
try {
con = getConnection();
sql = "select * from student";
PreparedStatement pst = con.prepareStatement(sql);
ResultSet rs = pst.executeQuery();//执行sql语句
while (rs.next()) {
System.out.print(rs.getString(1) + "\t");//rs.getString(1) 就是得到第一列
}
} catch (SQLException ce) {
System.out.println(ce);
}
}

public static void main(String[] args) {
SQLServer jdbctest1 = new SQLServer();
jdbctest1.display();
}
}

Answer 2

public List<Student> getList() {
String sql = "select * from student";
return tempdao.query(sql, null, new ITemp() {
public Object getParmet(ResultSet rs) throws SQLException {
Student stu = new Student();
stu.setStuId(rs.getInt("stuId"));
stu.setStuName(rs.getString("stuName"));
stu.setStuAge(rs.getInt("stuAge"));
stu.setStuSex(rs.getString("stuSex"));
return stu;
}

读取的

Answer 3

Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=52moy";
//mydb为数据库
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);

Answer 4

连接什么数据库？不同的数据加载的驱动程序不同，URL地址也不同，并且要找好对应数据库的驱动包(jar包)
下面以oracle的连接做示范

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class ConnectOracle {

private static final String DRIVER = "oracle.jdbc.driver.OracleDriver";

private final static String ORACLE_URL = "jdbc:oracle:thin:@192.168.1.100:1521:freedom";

private final static String USER = "scott";

private final static String PASSWORD = "freedom";

public static Connection getConnection() throws SQLException {
try {
Class.forName(DRIVER);//加载驱动程序
} catch (ClassNotFoundException e) {
e.printStackTrace();
}

return DriverManager.getConnection(ORACLE_URL, USER, PASSWORD);
}

public static void main(String[] args) throws SQLException {
Connection con = getConnection();
String sql = "select * from t_category";
PreparedStatement ps = con.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
while(rs.next()) {
System.out.println(rs.getString("id"));
System.out.println(rs.getString("name"));
System.out.println(rs.getString("description"));
System.out.println();
}
rs.close();
ps.close();
con.close();
}
}