求教java中操作mssql语句和存储过程几个常用的方法和函数？

Question

java.sql.Connection sqlConn; 
java.sql.Statement sqlStmt; 
java.sql.ResultSet sqlRst; //regiester jdbc driver 
Class.forName("org.gjt.mm.mysql.Driver").newInstance(); 
//connect to the database 
sqlConn=java.sql.DriverManager.getConnection 
("jdbc:mysql://192.168.0.1:3306/test?useUnicode=true&characterEncoding=gb2312","root",""); 
//create the driver handle 
sqlStmt=sqlConn.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY); 
//excute sql 
sqlRst=sqlStmt.executeQuery("select * from name"); 
while(sqlRst.next()) 
{
System.out.println(sqlRst.getString(1));
System.out.println(sqlRst.getString(2));
}
sqlRst.close(); 
sqlStmt.close(); 
sqlConn.close(); 
存储过程没有用过，呵呵，等别人写罗