myclips连接mysql_使用my exclipse对数据库进行操作(1)

一.查找

public class class1 {

public static void main(String[] args) {

// TODO Auto-generated method stub

try {

//1.找到数据库，并且链接上

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

Connection conn = DriverManager.getConnection("jdbc:sqlserver://192.168.8.60;DataBaseName=School","sa","123456");

//3.创建数据库输出方式SQL语句

String sql= "select [sid],[stuName],[sex],[age] from [Student]";

//2.取出数据库中的数据以SQL的方式

Statement stmt= conn.createStatement();

//4.取出所有的数据库的数据

ResultSet rst = stmt.executeQuery(sql);

//5.将数据库中的数据一个个取出来

while(rst.next()){

int one=rst.getInt("sid");

String two= rst.getString(2);

String three = rst.getString(3);

int fore = rst.getInt(4);

System.out.println("学号为："+one+"，的名字是"+two+",性别是"+three+",年龄是："+fore);

}

//6.关闭数据

if(!rst.isClosed()){

rst.close();

}     if(!stmt.isClosed()){

stmt.close();     }

if(!conn.isClosed()){

conn.close();     }

} catch (ClassNotFoundException e1) {

// TODO Auto-generated catch block     e1.printStackTrace();

}catch (SQLException e) {

// TODO Auto-generated catch block     e.printStackTrace();    }

}