程式設計工藝大師

2016年4月29日星期五

4/29

<legend>Demo: Get Value of Selected</legend>

<p>Select a shipping method:</p>

<p>

</p>

<p><button type="button" name="getVal">Get Value of Selected</button></p>

</fieldset>

</form>

// to remove from global namespace

(function() {

function getRadioVal(form, name) {

var val;

var radios = form.elements[name];

for (var i=0, len=radios.length; i<len; i++) {

if ( radios[i].checked ) {

val = radios[i].value;

break;

}

return val;

}

document.forms['demoForm'].elements['getVal'].onclick = function() {

alert( 'The selected radio button\'s value is: ' + getRadioVal(this.form, 'ship') );

};

// disable submission of all forms on this page

for (var i=0, len=document.forms.length; i<len; i++) {

document.forms[i].onsubmit = function() { return false; };

}

}());

</script>

2016年4月22日星期五

2016年4月15日星期五

4/15

package haha;

import java.sql.Connection;

import java.sql.DriverManager;

public class haha {

public static void main(String[] args) {

// TODO Auto-generated method stub

System.out.println("Hello! World!");

Connection c = null;

try {

Class.forName("org.sqlite.JDBC");

c = DriverManager.getConnection("jdbc:sqlite:test.db");

} catch (Exception e) {

System.err.println(e.getClass().getName() + ": " + e.getMessage());

System.exit(0);

}

System.out.println("Opened database successfully");

}

2016年4月1日星期五

public class HelloWorld {
public static void main(String[] args) {
System.out.println("Hello! World!");
}
}
___________________________________________________
package text1;
import java.sql.Connection;
import java.sql.DriverManager;
public class text1 {

public static void main(String[] args) {
// TODO Auto-generated method stub
Connection c = null;
try {
Class.forName("org.sqlite.JDBC");
c = DriverManager.getConnection("jdbc:sqlite:test.db");
} catch (Exception e) {
System.err.println(e.getClass().getName() + ": " + e.getMessage());
System.exit(0);
}
System.out.println("Opened database successfully");

}

}

2016年3月18日星期五

第五週匯出資料庫到網頁

eclipse連接到mysql

http://blog.yslifes.com/archives/918 <-這個網址按照步驟做

package db;

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

public class jdbcmysql {
private Connection con = null; //Database objects
//連接object
private Statement stat = null;
//執行,傳入之sql為完整字串
private ResultSet rs = null;
//結果集
private PreparedStatement pst = null;
//執行,傳入之sql為預儲之字申,需要傳入變數之位置
//先利用?來做標示

private String dropdbSQL = "DROP TABLE User ";

private String createdbSQL = "CREATE TABLE User (" +
" id INTEGER " +
" , name VARCHAR(20) " +
" , passwd VARCHAR(20))";

private String insertdbSQL = "insert into User(id,name,passwd) " +
"select ifNULL(max(id),0)+1,?,? FROM User";

private String selectSQL = "select * from User ";

public jdbcmysql()
{
try {
Class.forName("com.mysql.jdbc.Driver");
//註冊driver
con = DriverManager.getConnection(
"jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=Big5",
"","");
//取得connection

//jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=Big5
//localhost是主機名,test是database名
//useUnicode=true&characterEncoding=Big5使用的編碼

}
catch(ClassNotFoundException e)
{
System.out.println("DriverClassNotFound :"+e.toString());
}//有可能會產生sqlexception
catch(SQLException x) {
System.out.println("Exception :"+x.toString());
}

}
//建立table的方式
//可以看看Statement的使用方式
public void createTable()
{
try
{
stat = con.createStatement();
stat.executeUpdate(createdbSQL);
}
catch(SQLException e)
{
System.out.println("CreateDB Exception :" + e.toString());
}
finally
{
Close();
}
}
//新增資料
//可以看看PrepareStatement的使用方式
public void insertTable( String name,String passwd)
{
try
{
pst = con.prepareStatement(insertdbSQL);

pst.setString(1, name);
pst.setString(2, passwd);
pst.executeUpdate();
}
catch(SQLException e)
{
System.out.println("InsertDB Exception :" + e.toString());
}
finally
{
Close();
}
}
//刪除Table,
//跟建立table很像
public void dropTable()
{
try
{
stat = con.createStatement();
stat.executeUpdate(dropdbSQL);
}
catch(SQLException e)
{
System.out.println("DropDB Exception :" + e.toString());
}
finally
{
Close();
}
}
//查詢資料
//可以看看回傳結果集及取得資料方式
public void SelectTable()
{
try
{
stat = con.createStatement();
rs = stat.executeQuery(selectSQL);
System.out.println("ID\t\tName\t\tPASSWORD");
while(rs.next())
{
System.out.println(rs.getInt("id")+"\t\t"+
rs.getString("name")+"\t\t"+rs.getString("passwd"));
}
}
catch(SQLException e)
{
System.out.println("DropDB Exception :" + e.toString());
}
finally
{
Close();
}
}
//完整使用完資料庫後,記得要關閉所有Object
//否則在等待Timeout時,可能會有Connection poor的狀況
private void Close()
{
try
{
if(rs!=null)
{
rs.close();
rs = null;
}
if(stat!=null)
{
stat.close();
stat = null;
}
if(pst!=null)
{
pst.close();
pst = null;
}
}
catch(SQLException e)
{
System.out.println("Close Exception :" + e.toString());
}
}

public static void main(String[] args)
{
//測看看是否正常
jdbcmysql test = new jdbcmysql();
test.dropTable();
test.createTable();
test.insertTable("yku", "12356");
test.insertTable("yku2", "7890");
test.SelectTable();

}
}

<?php
$servername = "127.0.0.1";
$username = "root";
$password = "";
$dbname = "test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM `user`";
$result = $conn->query($sql);

if ($result != null) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "id: " . $row["name"] . $row["passwd"]. "<br>";
}
} else {
echo "0 results";
}
$conn->close();
?>

2016年3月11日星期五

匯出資料庫到網頁

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT * FROM `user`";
$result = $conn->query($sql);

if ($result != null) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "id:" . $row["name"]. $row["passwd"]. "<br>";
}
} else {
echo "0 results";
}
$conn->close();
?>

2016年2月18日星期四

打開JAVA

打開JAVA

import java.sql.Connection;
import java.sql.DriverManager;
public class hyt {
public static void main(String[] args) {
// TODO Auto-generated method stub
Connection c = null;
  try {
   Class.forName("org.sqlite.JDBC");
   c = DriverManager.getConnection("jdbc:sqlite:test.db");
  } catch (Exception e) {
   System.err.println(e.getClass().getName() + ": " + e.getMessage());
   System.exit(0);
  }
  System.out.println("Opened database successfully");
}
}

2016年4月29日 星期五

2016年4月22日 星期五

2016年4月15日 星期五

2016年4月1日 星期五

2016年3月18日 星期五

2016年3月11日 星期五